Concatinating query results of one field

[Kathy Webster]

How can I take the results of a query's email address field and lump them
together separated by semicolons so that they are ready to paste into the TO
line of an email?

Thank you!

 

[JohnFol]

You can only do this in VBA code.


I hope you are not asking for advice on spamming?

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You can
specify the delimiter in the call to the function.

 

[Kathy Webster]

Any suggestons, anyone???

 

[Duane Hookom]

Did you read my suggestion?

 

[John Vinson]

Any suggestons, anyone???

Use the VBA code at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]