Access quey result (emails) directly loaded into Outlook "TO" fiel
 

Hi,

I have an Access db that contains email addresses. What I would like to do
is that when I run a query and get a list of addresses. The resulting email
addresses can be loaded directly into Outlook "Send To" field by pressing a
button.
Can someone let me know how this can be done, thanks.

Regards,
MSA

Access quey result (emails) directly loaded into Outlook "TO" fiel
 

Iterate the query results and build a string of addresses separated by semicolons, then assign that string to the To property of the message.

However: if you create an send a message like that, you're violating the privacy of those people by revealing their email addresses to others. Consider performing mail merge in Word instead, to send individual messages.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"MSA" wrote in message ...
Hi,

I have an Access db that contains email addresses. What I would like to do
is that when I run a query and get a list of addresses. The resulting email
addresses can be loaded directly into Outlook "Send To" field by pressing a
button.
Can someone let me know how this can be done, thanks.

Regards,
MSA