collecting email addresses

[Kathy Webster]

I want to email to a group of people. After creating a select query, how
can I collect the desired [EmailAddresses], put commas between each address,
and
drop the result into a microsoft outlook TO field?

This is for a distributed runtime app, so it has to work for all versions of
outlook.

TIA,
Kathy

 

[Kathy Webster]

Any takers? This must be a tricky one. There was a reply on a previous
post, but he admitted it would not work on all versions of outlook, and had
lots of other issues as well. Plus, I have to admit it was WAY over my
head. For me, simple is best.

 

[Tony Toews [MVP]]

Any takers? This must be a tricky one. There was a reply on a previous
post, but he admitted it would not work on all versions of outlook, and had
lots of other issues as well. Plus, I have to admit it was WAY over my
head. For me, simple is best.

There is no simple way of doing what you are asking. A quick glance
at Gary's code showed it to be reasonable enough and it did cover the
situation with late binding and thus will work with all versions of
Outlook.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/