Hi AccessHelp

If you want that then use code from my site.
You can change and add what you want then.

http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"AccessHelp" wrote in message ...
Hello,

I use SendMail add-in to send my workbooks and worksheets using Outlook.
What I like to do is I would like to be able to populate the message "Sent
xx-xx-xx" (e.g. Sent 10-25-05) automatically in cell H1 of the sheet that I
use SendMail to mail my sheet. Can you guys help me with the coding?

At the same time, I don't want to mail any sheets using SendMail when there
is above message in cell H1. Please help.

Thanks.