How to copy column of email addresses and paste directly to addr

  • Thread starter Thread starter Mrs. Mc
  • Start date Start date
M

Mrs. Mc

I want to copy a column from an excel sheet and paste it directly to the
address on an email.... How do I make the tthe semicolons appear?
 
What happened when you tried it? What e-mail program are you using?

A program like Outlook is smart enough to put the separator in by itself.
You just copy the column and paste it in the "To:" box.

Another option is to add the semi-colon in Excel. In another column, use:
=a1&";"
Copy this down
Now copy and paste this column into the e-mail.

Regards,
Fred
 
Back
Top