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


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.
 
Ad

Advertisements

M

Michael Bednarek

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top