Solved: Sending a Automated Email Through Excel

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.

Squick

Thread Starter
Joined
Feb 7, 2012
Messages
5
Good Day,

I would like assistance in creating a code that will generate a automated email to specified receipients when a date is entered into a specific cell. I have attached a sample spreadsheet. When a "date" is added in column M, it automatically generates a email to specific recepients notifying the receipients that the specific unit number in column A has been completed.

For Example:

Good Day,

This is to notify you that unit *** (from colum A) is complete and ready for your team.

Thank You,

xxxx

Thank you very much for the assistance!
 

Attachments

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
First Name
Hans
Hi welcome to the forum.

See returned example.

A trigger on change macro in Sheet1 and teh VBA MailModule in the VBAProject

Chnage a date or add it in the date column to trigger the macro
 

Attachments

Keebellah

Trusted Advisor
Joined
Mar 27, 2008
Messages
6,611
First Name
Hans
:)
Don't forget to use the "Mark Solved" button to close the post
 

Squick

Thread Starter
Joined
Feb 7, 2012
Messages
5
Good Day Hans,

Thanks agian for creating this code, it worked out great. However, my company just change from Oulook to Gmail. Is it possible for the code to work for gmail as well?
 
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

Staff online

Members online

Top