Creating Email Reminders From 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.

Richlindsay16

Thread Starter
Joined
Aug 14, 2019
Messages
1
Hi,

I have created a workbook that tracks individuals qualifications that shows me those who need to renew in 90,60,30 days. I can toggle between the 3 or set different parameters if needed.

Instead of copying and pasting those details into an email i would like to be able to auto copy to another sheet and send a snapshot of the date required to renew to the individual and their line manager for 90,60,30 days

In my head I would have 3 buttons (or 4 if we could do an overdue one too) which i would press to pull through the info and send?

Is this possible and can you help??

Thanks
Richard
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,656
Hi Richard, wlecome to the forum.
Yes, your idea is possible and if you execute an extended search on this forum you'll find enough, will probably need a little tweaking to completly customize it to your needs.
You haven't mentioned the Excel version you're using and how far your VBA skills go, this last one for the tweaking of the vba code you may find.
Give it a search and then let us know. Re-inventing the wheel is not always really necessary
 
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