Combining Email Addresses

  • Thread starter Thread starter Tim Gallivan
  • Start date Start date
T

Tim Gallivan

I have a customer database that has an email address field associated with it.

I would like to concatenate all of the emails and add a " ; " for all
customers that are a part of agency 540. They end user needs to be able to
paste this into an email to hit all users within this agency.

1 & " ; " & [Email]2

Is there a simple way to do this function?
 
On Tue, 8 Sep 2009 12:22:25 -0700, Tim Gallivan <Tim
I have a customer database that has an email address field associated with it.

I would like to concatenate all of the emails and add a " ; " for all
customers that are a part of agency 540. They end user needs to be able to
paste this into an email to hit all users within this agency.

1 & " ; " & [Email]2

Is there a simple way to do this function?[/QUOTE]

You should be able to adapt the code at

http://www.mvps.org/access/modules/mdl0004.htm
Click to expand...
 
Thanks John ~

I found another way to do this via Excel. Thanks

John W. Vinson said:
On Tue, 8 Sep 2009 12:22:25 -0700, Tim Gallivan <Tim
I have a customer database that has an email address field associated with it.

I would like to concatenate all of the emails and add a " ; " for all
customers that are a part of agency 540. They end user needs to be able to
paste this into an email to hit all users within this agency.

1 & " ; " & [Email]2

Is there a simple way to do this function?[/QUOTE]

You should be able to adapt the code at

http://www.mvps.org/access/modules/mdl0004.htm[/QUOTE]
Click to expand...
Click to expand...
 
Back
Top