+ Reply to Thread
Results 1 to 2 of 2

Email (outlook) excel files to specified recipients based upon the file name

  1. #1
    Registered User
    Join Date
    11-12-2014
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    54

    Email (outlook) excel files to specified recipients based upon the file name

    Hi there,

    Using VBA, is it possible to email specific people (as outlined in the list below) so that that recipient is sent the file specified?

    File name (.xlsx) Email recipient
    12345 [email protected]
    15697 [email protected]
    16971 [email protected]
    20147 [email protected]
    50010 [email protected]
    60029 [email protected]


    Thanks in anticipation.

  2. #2
    Registered User
    Join Date
    11-28-2013
    Location
    Lima Peru
    MS-Off Ver
    Excel 2013
    Posts
    69

    Re: Email (outlook) excel files to specified recipients based upon the file name

    Assuming that you have the file names in column A and the email addresses in column B and all files belong to the "C:\" filepath, the following code should work:
    Please Login or Register  to view this content.
    Last edited by EduardoHiguchi; 02-11-2016 at 11:17 AM.

+ 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 send an email to multiple recipients from outlook with PDF.
    By marc5354 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-10-2015, 07:51 PM
  2. Sending Email to a List of Recipients Using Excel and Outlook
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2015, 04:33 AM
  3. Sending Email to a List of Recipients Using Excel and Outlook
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2015, 09:02 AM
  4. Email (outlook) recipients attaching specific file name.
    By monkeypants in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 05-13-2015, 07:18 PM
  5. Email (outlook) recipients attaching specific Excel file name.
    By monkeypants in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-13-2015, 07:14 PM
  6. Replies: 4
    Last Post: 01-02-2014, 12:19 PM
  7. Having Excel 2010 auto-generate an email to recipients in outlook 2010
    By dmcmillo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2012, 08:23 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