+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Blaine, mn
    MS-Off Ver
    2007
    Posts
    65

    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!!

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to Copy Emails in Excel to BCC line in Outlook 365 email for Holiday Ecard mailin

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Count Emails in outlook mail box and enter count and oldest email date into excel cell
    By fireguy7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2018, 11:04 AM
  2. Copy specific text from Outlook emails to Excel
    By Noel7 in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2015, 09:24 AM
  3. Help getting one line of email text from Outlook to Excel cell
    By ghladik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2015, 09:34 PM
  4. [SOLVED] Email Macro for Daily Emails via Outlook - Please assist!
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-27-2013, 01:25 PM
  5. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  6. Replies: 2
    Last Post: 08-01-2012, 02:47 PM
  7. Copy the body of an existing email in new emails generated via Excel with VBA.
    By e_lefebvre@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2006, 05:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1