vba help!!Automatic sender in excel

[sunny2u86]

Hello,


can any one help me!
my problem is that i need to sent a mail after every hour with a same text but the time is different for the next mail..
the following is the sample body that may help you to write the code:

from:[email protected]
to: [email protected](it may be more)
cc:[email protected](it may be more)
subjectlease help!

body of mail

hi sir/madam

dateresent date
time:21:45:10 AM CST (this time must be in decreasing order when i sent the same mail after 1 hrs or more!!)

text:


here may be any text:



thanks:
my signature of outlook
----------------end of mail-----------
what i want that after every hour excel will gave me popup as a reminder that its time to send the mail and when i press the send or OK button it past all information in the outlook message send window.but the time in the time field must be in decreasing order for example
1 mail has a time:21:45:10 PM CST
2 mail has a time:20:40:55 PM CST
3 mail has a time:19:32:12 PM CST

so if any one can help then please help!!


thanks

[westconn1]

the following is the sample body that may help you to write the code:

we can help you to write your own code, not do all for you

check out the tutorial for automating office applications (including outlook) in the faq thread at the top of this forum

you can use application.ontime in excel to schedule the next mail each time