Export Access field using VBA to Outlook Message Window

[djjohnst]

I am not 100% sure how to do this. I have an Access Database and am
going to be creating queries from the data. The most important field
is going to be the e-mail field because once the user has the right
query I want them to be able to click "E-mail" and it will take all
the e-mails and open their outlook, create a new message window, and
drop all the E-mails into the "To" box. I have looked around but i'm
not sure how to make the Access VBA do this. Anyone have any tips or
done something similar? Thank you for your time!

 

[pietlinden]

I am not 100% sure how to do this. I have an Access Database and am
going to be creating queries from the data. The most important field
is going to be the e-mail field because once the user has the right
query I want them to be able to click "E-mail" and it will take all
the e-mails and open their outlook, create a new message window, and
drop all the E-mails into the "To" box. I have looked around but i'm
not sure how to make the Access VBA do this. Anyone have any tips or
done something similar? Thank you for your time!

dig around for examples of Outlook automation...

I know there's a good example here... (I've used it)

http://amazecreations.com/datafast/ShowPage.aspx?File=CodePages/codeoutlookmail.asp

You would create the e-mail message and then before sending it, add
the recipients to the message.

dim rsRecipients as dao.recordset

set rsRecipients = currentdb.openrecordset("SELECT EMailAddress FROM
MyTable;",dbOpenSnapshot)

do until rsRecipients.EOF
mItem.Recipients.Add rsRecipients.Fields("EMailAddress")
rsRecipients.MoveNext
Loop

 

[Guest]

Hi

I may not be understanding just what it is you ae trying to do.

I think you want to click an e mail address and open the e mail with the TO
filled in.

If this is right you don't need any code. Just ensure the e mail address is
stored in the table as Mail:[email protected]

The Mailto: is the important bit. When you click this it will open outlook
(if set as mail serve) and fill in the mail to address for you.

If you wanted you can write a small amunt of code to include the subject and
even a small message

good luck

 

[djjohnst]

What would this small amount of code be? I'm looking more to fill the
BCC line... I figured out how to do everything else i just want to
fill the bcc line.