+ Reply to Thread
Results 1 to 5 of 5

send an email to multiple receipients that are listed in ONE cell (office 2016)

  1. #1
    Registered User
    Join Date
    05-06-2017
    Location
    Canada
    MS-Off Ver
    Office 365 subscription
    Posts
    43

    send an email to multiple receipients that are listed in ONE cell (office 2016)

    Hi, I have searched the internet for a solution to send a message to multiple recipients. It is possible using Mail Merge in Microsoft Word.
    But here's the issue in my case:
    phil and peter are the names, but this email should be sent to the two email accounts that are in the email column corresponding to the name-column. I receive an error when trying to send the email, even though when copy pasted into the address field in outlook the addresses are valid and recognized as such.

    Is there a way to do it? I tried different kinds of separators, , ; and "space"

    3QveTz0.png
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,396

    Re: send an email to multiple receipients that are listed in ONE cell (office 2016)

    I think having the linefeeds between the email addresses might be affecting the outcome. Obviously there is more to this application than is shown in the attachment.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    05-06-2017
    Location
    Canada
    MS-Off Ver
    Office 365 subscription
    Posts
    43

    Re: send an email to multiple receipients that are listed in ONE cell (office 2016)

    I've been trying for days to get that to work, no success so far, the linefeeds aren't the problem as I have testet pretty much every combination of seperators, delimiters... on the official microsoft support page it says: "Email: where each recipient's address is the only address on the To line. You'll be sending the email directly from Word." (https://support.microsoft.com/en-us/...f-932c49474705) I think it's not possible using this method. It might be using some combination of Excel, Outlook and VBA, but that is far beyond my capabilities. Or some completely different method, a third party tool maybe.

  4. #4
    Registered User
    Join Date
    03-04-2021
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    32

    Re: send an email to multiple receipients that are listed in ONE cell (office 2016)

    Hi MinisoftEggshell,

    dflak is correct on the linefeed issue. By having this additional "alt enter" line inserted within the singular cell, Outlook will only pickup the first actual line of text, not the second one. This can be tested by simply copying and pasting the original "email" column that you had provided - take B2 for example, and pasting it into Outlook in the "To" field. Only one email address will show up.

    That being said, the simplest issue to your problem would be to remove the second line within the cell, you can do so by placing your cursor in front of the second email address and hitting the Backspace key once.

    I have attached a copy of your spreadsheet that has your original, then an updated version with the removals of the second line, which you can see does work by following the same test as outlined above, and a proposed method that includes some helper columns and a column that then combines the email addresses together via a formula. Note that the proposed method is not necessary, however I don't know your actual application for this and figured it could potentially give you an idea to work with.
    Attached Files Attached Files
    Last edited by Chase Casey; 03-21-2022 at 12:10 PM.

  5. #5
    Registered User
    Join Date
    05-11-2022
    Location
    United States
    MS-Off Ver
    SoftwareKeep
    Posts
    3

    Re: send an email to multiple receipients that are listed in ONE cell (office 2016)

    This works for me in MS Word 2016 I'll try to explain. 1. Select any cell(s) from where you want to copy the email addresses. 2. Select Formulas Tab and click on "Insert Function" 3. In the search box enter "=hyperlink" 4. select "hlinks" in the Function drop down 5. Click OK

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use Function listed in this webpage to send email
    By Ravisca2003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2018, 11:51 PM
  2. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  3. VBA Send email from outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2017, 01:29 PM
  4. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  5. macro which sends email to few receipients with a standard message
    By megtoma in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2014, 07:57 AM
  6. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  7. [SOLVED] How do use outlook express to send email in office 2003
    By How do use outlook express to send email in forum Excel General
    Replies: 1
    Last Post: 07-19-2005, 08:05 AM

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