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?

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/micro...e7f6921bed3101
--
Wayne
Manchester, England.



"Adam" wrote:

> 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?

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.

--
Roger


"Adam" wrote:

> 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?

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.

"Roger" wrote:

> 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.
>
> --
> Roger
>
>
> "Adam" wrote:
>
> > 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?