Combining multiple fields into one string

[jh]

I have a datasheet subform that has email multiple email
addresses. I would like to export these email addresses
into one string separated by an "; " so that I can just
cut and paste them into my TO line in Outlook.

Is there a way to do this?

Thanks in advance.

 

[Duane Hookom]

There is a sample that demonstrates how to concatenate multiple records
together at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane