Hi..I want to routine an email automatically on 3 days basis.

  • Thread starter Thread starter asmitadhavale
  • Start date Start date
A

asmitadhavale

Hi..I want to routine an email from outlook with the help of data maintained in the tracker - EXCEL SHEET. How do I go about it? Please advice.

I want outlook express to take the data from the excel sheet, paste it in the mail and send it to the concerned team automatically. This activity should happen automatically at the interval of 3 days.

Please advice and help me with necessary steps to be taken.

Thank you.
 
Hi..I want to routine an email from outlook with the help of data maintained in the tracker - EXCEL SHEET. How do I go about it? Please advice.

I want outlook express to take the data from the excel sheet, paste it in the mail and send it to the concerned team automatically. This activity should happen automatically at the interval of 3 days.

Please advice and help me with necessary steps to be taken.

Thank you.
Click to expand...

To get started, you should look at the various topics that come up when
you enter "send mail" into Excel's help/assistance system.

Once you got the "send mail"-functionality going as a VBA macro, you can
write a VBS script which will start Excel with your workbook and run the
macro and use that to schedule the event using the Windows scheduler.
 
Back
Top