Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge - labels
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge - labels
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Louise wrote: 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge to continuous labels skips labels between pages | Mailmerge | |||
Mail Merge - How do I set-up Home Phone & e-mail lines on labels? | Mailmerge | |||
Mail merge labels will not fully merge | Mailmerge | |||
How do I e-mail mail-merge made labels? | Mailmerge | |||
Word Labels into Mail Merge Labels | Mailmerge |