Results 1 to 10 of 10

Sending a mass email using addresses in excel/outlook

This is a discussion on Sending a mass email using addresses in excel/outlook within the Excel Questions forums, part of the Question Forums category; Hello all, Once again I have a problem. i am trying to figure out how I can send a mass ...

  1. #1
    New Member
    Join Date
    Mar 2005
    Posts
    7

    Default Sending a mass email using addresses in excel/outlook

    Hello all,

    Once again I have a problem. i am trying to figure out how I can send a mass email to all of the email addresses that are stored on an excel spreadsheet. (It is a membership list)

    I know that I can import all of the emails into the contact list, but there are about 500 and it would clutter the contacts. Moreover, the list in excel can change from day to day and I wouldn't want to have to maintain the current contacts.

    Pretty much, I am looking for away to import this information for one email at a time.

    Any suggestions?

    Thanks,
    Emily

    P.S.

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    65,842

    Default

    Emily

    What do you actually wnat to send?

    Have you tried a search on this board?

    What email program are you using?
    If posting code please use code tags.

  3. #3
    Board Regular PA HS Teacher's Avatar
    Join Date
    Jul 2004
    Location
    Rochester, NY
    Posts
    2,838

    Default

    How about this:

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book2___Running: xl2000 : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    Include?
    2
    Person_2@yahoo.comxPerson_2@yahoo.com,
    3
    Person_3@comast.net Person_2@yahoo.com,Person_3@comast.net,
    4
    Person_4@comast.netxPerson_2@yahoo.com,Person_3@comast.net,
    5
    Person_5@comast.net Person_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,
    6
    Person_6@comast.net Person_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,
    7
    Person_7@comast.netxPerson_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,
    8
    Person_8@comast.net Person_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,Person_8@comast.net,
    9
    Person_9@yahoo.com Person_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,Person_8@comast.net,
    10
    Person_10@hotmail.comxPerson_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,Person_8@comast.net,
    11
    Person_11@yahoo.com Person_2@yahoo.com,Person_3@comast.net,Person_5@comast.net,Person_8@comast.net,Person_11@yahoo.com,
    12
    Sheet3 (2)
    Hyper Lynks Address is here ...

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


    In C2 and pasted down:
    =C1&IF(LEN(B1)>0,A2&",","")

    Then Just copy and paste into the To: of your e-mail. (don't forget to take off the last comma.

  4. #4
    New Member
    Join Date
    May 2010
    Location
    Canada
    Posts
    33

    Default Re: Sending a mass email using addresses in excel/outlook

    This is my exact question too.

    I have a couple different excel sheets with email addresses, for existing and potential clients. The excel sheets are set up depending on the type of client. I don't want to store the emails in outlook but want to be able to import them from my excel sheet to outlook. I am having trouble figuring this out. I thought I would be a simple task. When I tried it to send out an invite (regular outlook email) the steps I followed from some instructions I had found online had made a seperate address book with the email addresses but it was very difficult to then add them to the email as the set up was all weird. Also too, I don't want them stored in outlook. Plus the lists changes daily as new clients are added every day.

    Can anyone expand on the replies already listed here (above)?

    Thank you, in advance, for your assistance on this matter. Your feed back is greatly appriciated!

    Quote Originally Posted by Ereece View Post
    Hello all,

    Once again I have a problem. i am trying to figure out how I can send a mass email to all of the email addresses that are stored on an excel spreadsheet. (It is a membership list)

    I know that I can import all of the emails into the contact list, but there are about 500 and it would clutter the contacts. Moreover, the list in excel can change from day to day and I wouldn't want to have to maintain the current contacts.

    Pretty much, I am looking for away to import this information for one email at a time.

    Any suggestions?

    Thanks,
    Emily

    P.S.

  5. #5
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,790

    Default Re: Sending a mass email using addresses in excel/outlook

    All
    Have a look at Ron DeBruins site for ALL methods of E-Mailing Excel stuff

    www.rondebruin.nl/
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  6. #6
    New Member
    Join Date
    May 2010
    Location
    Canada
    Posts
    33

    Default Re: Sending a mass email using addresses in excel/outlook

    Thank you so much for your reply. I checked out his site, looks like a lot of good info. One question though, perhaps I am mis-understanding... his threads explain how to send an email FROM Excel directly... I could not find anything on how to IMPORT email addresses listed in an excel document into a one time outlook email....

    thanks again for your feedback..

    Quote Originally Posted by Michael M View Post
    All
    Have a look at Ron DeBruins site for ALL methods of E-Mailing Excel stuff

    www.rondebruin.nl/

  7. #7
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,790

    Default Re: Sending a mass email using addresses in excel/outlook

    If it is a one-off can't you copy and paste the range of Addresses from Excel into the
    To: Box in Outlook.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  8. #8
    New Member
    Join Date
    May 2010
    Location
    Canada
    Posts
    33

    Default Re: Sending a mass email using addresses in excel/outlook

    The excel sheet is also like an address book and client info...
    ie.
    Column A is Client Name, B-E is Client Billing/Shipping Address, F-H are Phone Numbers, I is email address... each row has a different client... each sheet can have couple hundered clients.

    I want to extract the email addresses into outlook to send a bulk email to them all in one shot.

    I have tried to copy/paste a full column but it doesn't seperate them with a seperator unless I am doing something wrong.

    Thanks so much!

    Quote Originally Posted by Michael M View Post
    If it is a one-off can't you copy and paste the range of Addresses from Excel into the
    To: Box in Outlook.

  9. #9
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    9,790

    Default Re: Sending a mass email using addresses in excel/outlook

    Have a look here:
    This shows how to Import the names into Outlook and set up a Distribution list for mailing.
    http://www.uws.edu.au/__data/assets/...from_Excel.pdf

    HTH
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  10. #10
    New Member
    Join Date
    May 2010
    Location
    Canada
    Posts
    33

    Default Re: Sending a mass email using addresses in excel/outlook

    THANK YOU VERY MUCH MICHAEL!!!!

    I will give those a try... I have search so long for something that simple... had no luck...

    I will let you know how it works out!!!

    Quote Originally Posted by Michael M View Post
    Have a look here:
    This shows how to Import the names into Outlook and set up a Distribution list for mailing.
    http://www.uws.edu.au/__data/assets/...from_Excel.pdf

    HTH

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com