+ Reply to Thread
Results 1 to 3 of 3

Macro to issue emails to multiple recipients with specific attachment

  1. #1
    Registered User
    Join Date
    03-07-2018
    Location
    AUSTRALIA
    MS-Off Ver
    2010
    Posts
    11

    Macro to issue emails to multiple recipients with specific attachment

    Hi All,
    I have a weekly a task where I need to notify users of unactioned items.
    Is there a quick way to email users with attachments corresponding to their own email addresses?

    Eg.
    Name Email address Error number
    1. J Bloggs [email protected] A001141
    2. MJones [email protected] C001141
    3. J Bloggs [email protected] D001141

    From above I need one email to go to J Bloggs with one attachment for lines 1 and 3
    And another email to MJones with attachment for line 2.

    Is this possible??
    Thanks
    A

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

    Re: Macro to issue emails to multiple recipients with specific attachment

    I think we need a bigger picture

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    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
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: Macro to issue emails to multiple recipients with specific attachment

    If you do a search on this forum you'll find a number of solutions which with minor editing will help you
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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 Email With PDF Attachment Macro to Multiple Recipients
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2018, 10:34 PM
  2. VBA macro to send emails to list of recipients.
    By GNTS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2017, 10:06 PM
  3. [SOLVED] Send multiple emails to multiple recipients
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-04-2017, 09:26 AM
  4. [SOLVED] Email as PDF attachment for multiple recipients
    By majime01 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-17-2016, 04:16 PM
  5. [SOLVED] Send multiple emails with one attachment each
    By unix17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2016, 08:02 PM
  6. Help with Macro to email attachment to multiple recipients
    By markharris2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2014, 08:48 AM
  7. Sending emails to multiple recipients through VBA
    By MikeFranz123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2014, 09:47 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