[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/boo...x#AboutTheBook

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

"whiter" wrote in message
...
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!

[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

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"whiter" wrote in message
...
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!

[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.




"whiter" wrote in message
:

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

"Beth Melton" wrote:


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:
HYPERLINK "http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook"http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

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

"whiter" HYPERLINK "whiter@di scussions.microsoft.com wrote in message
...

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!





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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"whiter" wrote in message
...
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

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"whiter" wrote in message
...
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!