automate email from MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 16 Jan 2008 20:22 GMT

I have email addresses in an Access table that i want to drop into a "to"
field of a a new message - can i automate this? CAn i also do it for an email
i have saved as draft or canned message?

Reply to this Message

Wayne-I-M - 16 Jan 2008 20:44 GMT

Hi Adam

As long as you can display the address in a text box on a form there's no
problems.

Have a look at this post

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/d027
ec1c58326b5a/f4e7f6921bed3101?lnk=st&q=#f4e7f6921bed3101

Signature

Wayne
Manchester, England.

> I have email addresses in an Access table that i want to drop into a "to"
> field of a a new message - can i automate this? CAn i also do it for an email
> i have saved as draft or canned message?

Reply to this Message

Roger - 17 Jan 2008 01:09 GMT

Here's what I like to do.

I have a few applications for which I send bulk e-mails. Thus I need to
save a the "native" e-mail address which I do in a field I call EMailText. I
also like to hyperlink another field to directly open my e-mail client and
place the address in the "to:" line. In order to do so, I need "MailTo:" in
front of the e-mail address (Microsoft, of course, adds some of their own
stuff to differentiate it from an Http hyperlink.) To have both
capabilities, here's what I do:

In the AfterUpdate event of the EMailText field I simply write:

Me.EMailHyper = "MailTo:" & Me.EMailText

I now have both. To keep the end user from making mistakes, I lock
EMailHyper.

I hope that addresses your issue.

Signature

Roger

> I have email addresses in an Access table that i want to drop into a "to"
> field of a a new message - can i automate this? CAn i also do it for an email
> i have saved as draft or canned message?

Reply to this Message

Adam - 18 Jan 2008 20:15 GMT

Hello Roger,

I'm not sure i understand..?
I have email addresses in one field in a table. I already created a button
that opens ms outlook - I want to add code to the button or run a macro that
will take the addresses (one at a time, or many - depending on how many email
address i have that day as it will be different from one day to the next).
And drop it in the too field of an email. The parts i'm missing is being able
to have the message open already when outlook opens and have the addresses
put in the to field.

Thansk.

> Here's what I like to do.
>
[quoted text clipped - 18 lines]
> > field of a a new message - can i automate this? CAn i also do it for an email
> > i have saved as draft or canned message?

Reply to this Message