+ Reply to Thread
Results 1 to 1 of 1

VBA help to send pdf attachments via Outlook to Excel distribution list

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    VBA help to send pdf attachments via Outlook to Excel distribution list

    Hi All,

    Please see attached.

    I need help with VBA code to add to my Excel Distribution list that when run, would look for the path, grab the file that starts with the cost centre number (in Col A), and attach to the email and issue to a pre-defined distribution list.
    The distribution list is shown above.
    Email (column E) will populate in the To: field
    Recipients (columns F to I) 2 to 5 in the CC: field
    I would want the email heading to be Fixed Text: "Cost Centre report for - May 2013 (obviously this will change depending on the months report which is being created).
    Within the Body of the text,
    I would like it to say
    Dear First name, (column C)
    Please find attached a copy of your cost centre report for May 2013 (again month will be determined by the file)
    Summary:
    Cost centre: (Column A)
    Cost centre Description (Column B)
    Cost centre Manager: First name & Surname.

    With thanks

    Signature (TBC)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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