Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I am using Word 2003.
I want to merge Word Address Labels #5160 with an Access Database. How do I trunicate the fields so that City, State and zip will fall correctly. And so that it will be address to "Male Name & Female name Last Name" as it should be but when records do not have a Male Name will be addressed directly to the "Female name and last name". I know I have done this before, but I am having a senior moment. Aurora |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Perhaps you did it all in Access before. It has a perfectly good Label
Wizard. In Word however, you just insert the mergefields that you require in the configuration that you require them, though I am not quite sure what you mean by trunicate (sic) the fields so that City, State and zip fall correctly. Do you mean abreviate the State field down to two Characters? Male Name Female Name bit use an If...then...Else field construction { IF { MERGEFIELD "Male Name" } "" "{ MERGEFIELD "Male Name" }{ IF { MERGEFIELD "Female Name" } "" " & { MERGEFIELD "Female Name" }" "" }" { MERGEFIELD "Female Name" } } But, I would do the data manipulation in an Access Query. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "AURORA" wrote in message ... I am using Word 2003. I want to merge Word Address Labels #5160 with an Access Database. How do I trunicate the fields so that City, State and zip will fall correctly. And so that it will be address to "Male Name & Female name Last Name" as it should be but when records do not have a Male Name will be addressed directly to the "Female name and last name". I know I have done this before, but I am having a senior moment. Aurora |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mailmerge Labels pulling info from Access and putting it into Word | Mailmerge | |||
Can I export Word labels into Excel or Access? | Microsoft Word Help | |||
How do you merge labels from a word document (Labels are 5366) | Mailmerge | |||
Adress labels to access to be able to do mail merge later | Mailmerge | |||
word opens access in mail merge. Access is already opened.=twice | Mailmerge |