I'm trying to do date labels for files(for everyday of the year). I auto
fill all the dates in a column in excel, but I can't get them over to Word.
When I'm going thru the mail merge wizard they show up in the mm/dd/yy format
at first, then on the next step it changes to next record And by the time
I finish the wizard it goes back to blank files. Could somebody give me some
good instructions. Also I need the date to display in the Monday July 18,
2005 format. I'm doing this for work and we dont want to type everyday out
manually, so thanks so much!!

Answered in another group...
*******************
~Anne Troy

www.OfficeArticles.com


"Jenny" wrote in message
...
I'm trying to do date labels for files(for everyday of the year). I auto
fill all the dates in a column in excel, but I can't get them over to
Word.
When I'm going thru the mail merge wizard they show up in the mm/dd/yy
format
at first, then on the next step it changes to next record And by the
time
I finish the wizard it goes back to blank files. Could somebody give me
some
good instructions. Also I need the date to display in the Monday July 18,
2005 format. I'm doing this for work and we dont want to type everyday
out
manually, so thanks so much!!

The general principles for label merges are covered at
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

Insert your Excel date field and use a formatting switch to provide the
format eg
{Mergefield MyDate \@ "dddd MMM d, yyyy"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Jenny wrote:
I'm trying to do date labels for files(for everyday of the year). I
auto fill all the dates in a column in excel, but I can't get them
over to Word. When I'm going thru the mail merge wizard they show up
in the mm/dd/yy format at first, then on the next step it changes to
next record And by the time I finish the wizard it goes back to
blank files. Could somebody give me some good instructions. Also I
need the date to display in the Monday July 18, 2005 format. I'm
doing this for work and we dont want to type everyday out manually,
so thanks so much!!

You don't say which version of Word you are using but it works OK for me in
2000. Format the dates in your Excel spreadsheet using the custom format
dddd d mmmm, yyyy so they look the way you want. When you are running the
mail merge wizard make sure you use Mailing Labels as the type of document
and just insert the date field when it gives you the sample label.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Jenny" wrote:

I'm trying to do date labels for files(for everyday of the year). I auto
fill all the dates in a column in excel, but I can't get them over to Word.
When I'm going thru the mail merge wizard they show up in the mm/dd/yy format
at first, then on the next step it changes to next record And by the time
I finish the wizard it goes back to blank files. Could somebody give me some
good instructions. Also I need the date to display in the Monday July 18,
2005 format. I'm doing this for work and we dont want to type everyday out
manually, so thanks so much!!

Andrea, things have changed a great deal with Word 2002, and it's a very
common question/problem. Ahhh....I love Word 2000 and use it most of the
time even though I have the newer versions.
*******************
~Anne Troy

www.OfficeArticles.com


"Andrea Jones" wrote in message
...
You don't say which version of Word you are using but it works OK for me
in
2000. Format the dates in your Excel spreadsheet using the custom format
dddd d mmmm, yyyy so they look the way you want. When you are running the
mail merge wizard make sure you use Mailing Labels as the type of document
and just insert the date field when it gives you the sample label.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"Jenny" wrote:

I'm trying to do date labels for files(for everyday of the year). I
auto
fill all the dates in a column in excel, but I can't get them over to
Word.
When I'm going thru the mail merge wizard they show up in the mm/dd/yy
format
at first, then on the next step it changes to next record And by the
time
I finish the wizard it goes back to blank files. Could somebody give me
some
good instructions. Also I need the date to display in the Monday July
18,
2005 format. I'm doing this for work and we dont want to type everyday
out
manually, so thanks so much!!