Concatenate string for SendObject Method

[RickB]

I have a query with a field called EmailAddress. I want to contatenate all
the email addresses from this query and separate addresses with a
semi-colon. I then want to place this concatenated string into the BCC field
of a new message created by the SendObject method.

Any assistance would be appreciated.

-rick

 

[Ken Snell [MVP]]

What you seek to do can be done via a VBA function that Duane Hookom, ACCESS
MVP, has written.
http://www.rogersaccesslibrary.com/...Generic+Function+To+Concatenate+Child+Records'

There also is another VBA function to do this at The ACCESS Web:
http://www.mvps.org/access/modules/mdl0004.htm

Either function could be called from your query.