certificates and mail merge

[Guest]

I created a certificate in word and have a mail merge field set up for the
name and the date. My data source was created in excel. Everything works
fine except for the date, in excel I formatted the date to appear as May 1,
2006...... but when the field shows on the certificate it is
5/1/2006.......Is there a way to have the date printed out as May 1,
2006...... instead of numbers?
Thanks

 

[Joseph Meehan]

I created a certificate in word and have a mail merge field set up for
the name and the date. My data source was created in excel.
Everything works fine except for the date, in excel I formatted the
date to appear as May 1, 2006...... but when the field shows on the
certificate it is 5/1/2006.......Is there a way to have the date
printed out as May 1, 2006...... instead of numbers?
Thanks

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.