Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Illinois, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Addresses from Excel (Office 2000 sp2)

    I want to send an email to a number of recipients, all of their email address are in an excel spreadsheet, although all of the entries in the spreadsheet don't have email addresses. How do I do this?

    Michele

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Addresses from Excel (Office 2000 sp2)

    Do a mail merge with Word.

    Set up a query that only chooses records where the email address field Is Not Blank.

    Once you've got it set up, hit Merge and instead of (the usual) merge to new document, choose to merge to Electronic Mail, then hit the Setup button, from which you can tell it what field name in your Excel file contains the email addy.

    Hope that helps!

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Addresses from Excel (Office 2000 sp2)

    since you are using sp2, i believe you'll have the security warnings on each message, if you are sending the email through outlook. you might want to switch to either OE as the default email program while you do the merge. Or use word and HTML format - i'm pretty sure it bypasses the security warnings. For more information on mail merging to outlook, see http://www.slipstick.com

Posting Permissions

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