Compiling email addresses from individual cells

S

SwimOff1

I'd like to send a single email to a couple hundred associates. Each email
address is listed in a separate cell in a single file column. I've
concatenated the list but can't figure out a way to capture the text (I can
capture the formula but I don't need that) so I can take it and paste it in
the address field. I'm using Excel 2003 SP1.
 
M

Mike H

Hi,

I assume you've done something like this to concatenate the addresses

=A1&";"&A2

Copy the cell with the concatenated addresses in and past then into another
cell with

Paste Special - Values

Copy this cell and paste into the address field

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the "From" email address VBA 0
Insert name and adress from a list in a word document 1
Auto Populate One Pages from spreadsheet 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Have 4 email addresses Want to auto forward all in one of them 0
Duplicate pst, or is it? 1
Office 365 Email Encryption One time Passcode 0
Outlook - Catgorizing emails by names 0

Top