+ Reply to Thread
Results 1 to 3 of 3

how to use email addresses from excel list to send individual e mails

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    north yorkshire, england
    MS-Off Ver
    Excel 2007
    Posts
    16

    how to use email addresses from excel list to send individual e mails

    Hi, Happy New Year,
    try not to laugh(or cry)
    I have set up a spreadsheet which holds data about various golf clubs.
    Included in this is their e mail address. I maybe should have tried to set this up in access?????
    However, what I want to do is to send individual e mails to selected clubs, ie not the whole list, such that this appears an individual email, not a spammy thing.
    So, to clarify, list of clubs with email addresses in a column.
    will have to input a column to identify if selected or not?
    Then to set up individual e mails, which attach/use a file as the message body, without doing it manually.
    Titles are across row 2, with the selected indicator in column A, email address in column B, ie data A3 and B3.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: how to use email addresses from excel list to send individual e mails

    Worth looking through Ron de Bruin's page in first instance - there are a multitude of examples - if you get stuck post back with what you have

    http://www.rondebruin.nl/sendmail.htm

  3. #3
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: how to use email addresses from excel list to send individual e mails

    Assuming that if you have Excel, you also have Word, you can do a plain vanilla Word Mail merge to Email instead of printing to paper. Just click the Mailings ribbon, then Start Mail Merge, then EMail messages, and follow the wizard. All without macros and fully customisable with selecting who to include in the email list.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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