Using email addresses from a table

[jacobh]

Hi again.

If I have a table with person data, including email addresses, how can I
generate a string af semikolon-separated email addresses that I can use in a
Bcc field in an email?

Or is there another way of sending emails from Access using email addressed
store in a table. A bit like mail-merge.

Thanks

Jacob

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.