Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Automate a mail from excel with attachment

Home Forums Office Office 2007 General Issues Automate a mail from excel with attachment

Viewing 1 post (of 1 total)
  • Author
    Posts

  • boseytal
    Member
    #160892

    Hi,

    I’m trying to automate a system through excel for sending emails to customers.
    What’s happening at the moment is that information is being manually entered into a spreadsheet for a customer (sales order, purchase order, contact, address etc). Then that customer has to be emailed a copy of sales order acknowledgement PDF, with a generic text body (Thanks you for ordering blah blah)

    What I’d like to do (and I’ve no idea if it’s possible) is to automate this procedure so that, for example, you’d have:

    Customer: Joe Bloggs
    SO: 12345
    PO: 54321
    Email: [email protected]; [email protected]

    If there was some sort of script/macro you could run in Excel to make it take the above details for any customers (all fields under same headings, with multiple emails) and open a generic mail template like:

    Dear [customer name]

    This is a confirmation email relating to your order [SO]

    Regards,
    Accounts.

    Also, I have a folder with various sales order acknowledgements PDF’s (all named after the SO eg: SO12345.pdf_ – is there a way to automate attaching this files to said email?

    Is this possible at all?

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: