+ Reply to Thread
Results 1 to 12 of 12

send email to multiple recipients

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: send email to multiple recipients

    I think where you are getting the error with .Resolve is... this is checking the names and it cannot determine that there are multiple names in one cell, so I believe it is treating it as one and giving you the error. Hopefully someone might chime in here that has dealt more with using .Resolve. Otherwise, you might have to ignore it, or rewrite some of the code and use the example I posted so the code will separate the names at each semi-colon.

  2. #2
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    596

    Re: send email to multiple recipients

    When your code separates the names, the e-mails will go out as separate e-mails with one single name under "To" or they will be "regrouped" as multiple E-mails in the "To" window of the Message?
    I mean if in Cell B2 I have 3 recipients, than I will have 3 e-mails going out?
    Thanks

+ 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. Send workbook via email to multiple recipients
    By jdavies294 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-16-2014, 10:44 AM
  2. [SOLVED] How to send Lotus email with VBA to more recipients and also to more copy recipients
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-20-2013, 03:23 PM
  3. send email from excel to multiple recipients
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2013, 01:41 PM
  4. Send email to multiple recipients
    By Court16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 05:20 PM
  5. Send workbook via email to multiple recipients
    By lethal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2008, 06:58 PM

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