Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

Mail merge - labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Louise - 09 Jun 2007 17:05 GMT
I am working with Excel 2003 and a large database. Part of what I am doing
involves makeing labels that include name and birthdate and SIN number.
After making my list with the birthdate formatted to dd-Apr-yyyy and sin 000
-000-000, when I go to Word to do labels, these two formats do not stay in
the column. They become dd/mm/yy and 000000000.
When I first started doing this, it was OK but now it is not working right.
Did I do something to cause it not to stay?
If I print the list as a list it stays as I want it, just not when I try to
do labels.
I am wondering if it could be that my computer is part of a large network.
I had just been saving the database to the desktop then I started saving it
to the main drive on the network so I wouldn't loose all the work I have done
as it is saved each night and it seems to have started after that.
A new Excel page saved to the desktop does the same thing.
Graham Mayor - 09 Jun 2007 17:30 GMT
There is nothing unusual about this - apply the switches that will give you
the layout you want to the merge fields -
http://www.gmayor.com/formatting_word_fields.htm

\@ "dd-MMM-yyyy"
and
\# "000'-'000'-'000"
respectively

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> I am working with Excel 2003 and a large database. Part of what I am
> doing involves makeing labels that include name and birthdate and SIN
[quoted text clipped - 13 lines]
> started after that.
> A new Excel page saved to the desktop does the same thing.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.