Tech Support Guy banner
Status
Not open for further replies.

Automatic Outlook reminder using excel data

1K views 1 reply 2 participants last post by  Keebellah 
#1 ·
Hello,

I have currently tasked myself with what i thought was an very easy and simple job of being able to set up a way of having an automated email system which uses excel data.

My data contains basic information about calibration dates, i need an email (reminder) sent to a specific email address 6 months prior to the calibration date using the dates in the excel spreadsheet as a reference for the 6 months to trigger an email.

By *automated* i mean the program doesn't necessarily have to be open and doesn't require anyone to hit a command button to send off the email, it should be done without any manual interference if it is even possible to do this.

I hope you can get back to me on this issue.

Many thanks,
Ryan
 
#2 ·
Hi, welcome to the forum.
I very long time ago I helped someone with a similar issue and automated mail .

The scheduling part was triggered using the Windows Scheduler and a vbs script to run the excel file with that macro.
I you do an extended search you'll probably find it since Excel and mailing though Outlook seems to be something many require.

I can suggest you this site to give you a start
https://www.rondebruin.nl/win/s1/outlook/mail.htm

I don't know what your level of VBA knowledge is but maybe this can help you.
Once you have something I'll gladly advice and help
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top