Mail Merge Date Format

[whiter]

I am having trouble with my date format in my mail merge.
I am using the date switch \@"mm,dd,yyy" but am still getting a #format.
It used to work before we changed to SP3 from SP2 in Office 2002.

HELP!

 

[Beth Melton]

Try using a capital "M" for the month instead of a lowercase "m". In Word a
lowercase m is for minutes. So what you need is: "MM, dd, yyyy".

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[whiter]

Thanks Beth.

Now I am getting 11,15, 2007. My format in excel is November 15, 2007, do I
need to change this? Even if I select, prefer format under edit funtions,
then I get a totally different date format?

Rebecca

 

[Dawn Crosier, Word MVP]

Since you want November, use MMMM
MMM will give you Nov

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.

Thanks Beth.

Now I am getting 11,15, 2007. My format in excel is November 15, 2007, do I
need to change this? Even if I select, prefer format under edit funtions,
then I get a totally different date format?

Rebecca

:



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.17.2/1184 - Release Date: 12/14/2007 11:29 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.17.2/1184 - Release Date:
12/14/2007 11:29 AM

 

[Suzanne S. Barnhill]

MM gives you the two-digit month; M gives you one or two digits as needed;
MMM gives you a three-letter abbreviation; for the full month name, you need
MMMM; see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm.