Automatic e-mail from excel

[Kesh]

Excel 2007.

Hi

I want to send an e-mail automatically from Excel. Can anybody please help me?

Thank you

Kesh

 

[Trevor G]

Have you looked at the DataPig Website that will give you a method to send out Emails from Excel. Check this link out and search down until you find Using Excel Macros.

http://www.datapigtechnologies.com/ExcelMain.htm

 

[Kesh]

Thank you Trevor. I will look into this

 

[Kesh]

Hi Trevor

i have looked at the website. It shows how to write the VBA code and assign it to a button.

I would like to the e-mail to be sent automatically every day at 8:00 a.m.

Any thoughts?

Thank you

Kesh

 

[Trevor G]

If you have permission to access your control panel on the desktop you can look at using the scheduler that is one idea, alternatively you would need to look at using time events in the VBA but you need to have the workbook open and pc on.

Alternatively if you are on a network you could ask the network administrators to set up an event that triggers the macro.

 

[Kesh]

Thank you Trevor

I have access to control panel and I know how to use the task scheduler. What I need specifically is the code for sending e-mails on excel automatically. I will take care of starting excel opening the workbook and closing it

Kesh

 

[Trevor G]

There are lots of websites if you google for Excel VBA Timer Event to run a macro.

Here is a link to help you along.
http://stackoverflow.com/questions/...ode-every-set-number-of-seconds-i-e-120-secon