concatenating EMail addresses

[Dave Sutton]

I have a field that holds Email addresses in a Mailto:
format. Is it possible to have Access send ALL the EMail
adresses in a table to our mail client 'To' field, instead
of going through each individual record and clicking on
the email address, which is obviously very time consuming
when you have 7000+ records!

Many Thanks.

 

[Duane Hookom]

There is a generic concatenate function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. I'm not
sure how many addresses your email client will accept...