How to Copy Emails in Excel to BCC line in Outlook 365 email for Holiday Ecard mailing?

Hello! I am in desperate need of help and am in a crunch to get this finished!

My company this year is sending out Ecards for Holiday wishes to our customers.

Here are the facts:

1. All email addresses are in Excel.
2. We have a photoshop ecard that we want to email to all addresses.
3. We want the memo line to say Merry Christmas and Happy Holidays.
4. We want the email addresses to go in the BCC line on the email (Outlook 365).

5. I have tried copying the emails and dumping them right into outlook 365 BCC line, but they don't appear they will take because there is not a semicolon behind each address.
6. This is a very long list and I don't want to import these into my outlook contacts.
7. I tried microsoft word, and all of a sudden I sent a blank email out to all of these recipients.


So how can I quickly and easily get all these email addresses into my Outlook 365 BCC line? Of course I have to get this out today and I have to have nothing but confusion, frustration and problems.

Your help is very much appreciated!!

are the emails in one col? if they are, the easiest way is to write code to spit out the string you can copy and paste into a message:

Please Login or Register  to view this content.