Macro to save filename with date/time stamp, then email

S

SpencerCAIC

Hi all,

Using Word 2003, I need a macro that will save a template as a .doc with the
date in the file name (e.g. AM20051102.doc) then send the file to a specified
email address.

I’m a VBA/macro novice. With the Macro recorder, I can get it to save, but
not with an automatically updating date in the filename, just the one I typed
when recording. It then opens the Send to Mail recipient, but no address is
filled in.

Thanks in advance for any help,

Spencer
 
D

Doug Robbins - Word MVP

Use a SaveDate field in the template to have the date that a document
created from the template is saved. Consider however whether a CreateDate
field might not be more appropriate as the SaveDate field will update each
time the document is saved, unless you unlink the field. To email the
document See the article "How to send an email from Word using VBA" at:

http://www.word.mvps.org/FAQs/InterDev/SendMail.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Top