+ Reply to Thread
Results 1 to 4 of 4

How can i send a huge email with different receive?

  1. #1
    Registered User
    Join Date
    05-22-2009
    Location
    HK
    MS-Off Ver
    Excel 2003
    Posts
    27

    How can i send a huge email with different receive?

    Let say, if i have a 100 person in my contact list, when i send to these 100 person, can i have different receiver?

    e.g
    Dear XXX

    test

    Regeards,
    Terry

    ------------------------------------------------
    i want the xxx will change when the email is change, and also can i hide the other email address when i send out?

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How can i send a huge email with different receive?

    put all addresses in the bcc field do not put any address in the to or cc field no one will know the others are included
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

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

    Re: How can i send a huge email with different receive?

    Sorry to burst you bubble, Martin, but your solution will not do the personalised greeting (Dear XXX).

    Terry, you need to use Word as your Email editor and then create an email, go Tools - Letter and Mailings - Mail merge. The wizard leads you through it. Make sure that you select to create an email. You can have your email addresses in an Excel spreadsheet and link to that. In the same Excel spreadsheet you should have the first name of the addressee in another column and you can then use that column for the Dear XXX variable.

    Read up on mail merge in the Word help. It's really not all that complicated.

    cheers

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How can i send a huge email with different receive?

    i misread it lol

+ 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