Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Send email (Excel 2003)

    I have an EXCEL file with over 300 email addresses on it (as well as phone numbers, mailing addresses, etc. in other columns). I really need, quickly, to send an email to all the email addresses. How can I paste the email addresses from a column in Excel to an email address field??

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Send email (Excel 2003)

    Does Ron deBruin's code at Mail a different file to each person in a range do what you want?

    Steve

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Send email (Excel 2003)

    One rather inelegant but effective method:

    Select and copy the cells with email addresses,
    Open Word and Edit | Paste Special as Unformatted text,
    Choose Edit | Replace and replace "^p" with ";" (don't include the quote marks),
    Copy the results and paste into your email's address field.

    In Word, ^p is code for the paragraph mark. The Edit | Replace changes your list from a column of email addresses to a single string separated by semicolons. You may need to delete an extra ";" from the end of the string. Depending on your email program, you may want to use a different replacement than the semicolon; whatever works.

    Aloha, JohnJ

Posting Permissions

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