Excel Macro to send emails based on multiple values

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Dave3157

Thread Starter
Joined
Apr 1, 2019
Messages
2
Good morning all,

My sincerest apologies if this has been posted before. I am brand new to the forum.

I am looking for some assistance with a Macro to read the time in Column D and generate an email in outlook (Or even better automatically send) to a predefined set of contacts based on the 3 letter code in Column C.

I work for a haulage company where we perform a check 5 hours prior to the vehicle arriving into the plant, and this is the function I am looking to automate. So as a recap quickly I need the following.


  • To link the 3 letter code in column C to a pre-determined list of email contacts
  • Email to generate/send at the times in Column D
  • Sending to all of the applicable linked contacts based on the 3 letter code in Column C
  • Email body and Subject pre-determined (E.G. "Please advise 5 hour checks for your vehicles")
  • Time slot spreadsheet to be attached to the email


upload_2019-4-2_8-32-50.png

Any help would be greatly appreciated. Please let me know if I need to provide any further detail, I have attached the sheet I am working to. (Please note that the list is split into 3 separate plants that our company delivers to)

Thank you all in advance for your support.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top