Insert Date of Creation

B

BadgerWI

Dear Folks,

I'm attempting to use Auto Text to create a start for letters, utilizing the
margins of our letterhead.

As part of that project, I would like to include a macro that shows the date
the letter was created, whereby the date does not change if the file is
opened a week or a year from the date of creation.

I'm struggling since if I use Today's Date, then the date shows today's date
in the future, rather than the date of creation.

Any help?

thanks
 
D

Dian D. Chapman, MVP

You need to create a template for the letter and use the CREATEDATE
field. Then each letter created from the template will hold the date
that letter was created.

See this TechTrax article for details...

Creating Your Own Letterhead
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=515

Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
 
B

BadgerWI

Thanks,

I'll take a look

Dian D. Chapman said:
You need to create a template for the letter and use the CREATEDATE
field. Then each letter created from the template will hold the date
that letter was created.

See this TechTrax article for details...

Creating Your Own Letterhead
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=515

Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top