Mail merge - labels

[Louise]

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]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>