creating email in Outlook with query data

[Guest]

i have created a query in access that contains all relevant biographical info
from our membership database. I have to take this info and email each member
(about 3,000 members). the email automatically contains that member's info.
how do i take the query and use it to populate an email, then only send one
email that goes to each member with his/her info?

Thanks!

 

[John Nurick]

Hi Sasha,

See http://www.granite.ab.ca/access/email.htm

 

[Guest]

Just in case you're still following this thread, I want to report success
with this process for a 400-member organization using World Merge
(www.coloradosoft.com). I have also done printed statements using Word's mail
merge, which apparently also will produce merged emails (although I haven't
tried that yet).