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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top