Sending excell with outlook

[suton]

I used following code for mail sending, can some1 help to make it on specific time and not using BUTTON.
Thanks.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

One way would be with the following Workbook Open event, Change the time (currently 11:00 a.m.) as necessary

Please Login or Register  to view this content.

[suton]

Nothing is happening...

Look at my file pls

[Richard Buttrey]

Hi,

Your your Mail_Workbook_1 procedure needs to be in a Module object not in the Workbook object

[suton]

i used "Right click insert modul and then past code in MODUL" and when i right time come nothing happend.

[suton]

Any1 could help in here

[Richard Buttrey]

It worked OK for me. Did you also remove it from the Workbook object.

Upload the actual workbook if you still have a problem.