| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail megre Address Problem
hi,
i'm newbee on mailmerge function. Right now, i have excel file that contrained address fields. e.g. col A colB colC 1 Flat Street Zip 2 18 xxxx st 950 3 yyyy st 913 4 12 jjjj st Then i wan to mail merge on my document as following Flat 18 ZIP 950 xxxxx st ZIP 913 yyyy ST Flat 12 jjjj st I can easily inset those word "Flat" and "ZIP". But if the cell is blank, it should not t print the word "Flat" and "zip". possible? tap thanks |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail megre Address Problem
You need two conditional fields:
{IF {Mergefield Flat} "" "Flat {Mergefield Flat}"} {IF {Mergefiield Zip} "" "Zip {Mergefield Zip}"} each placed where you want the information placed. The fields type in the standing text and the field only when the fields have content. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: hi, i'm newbee on mailmerge function. Right now, i have excel file that contrained address fields. e.g. col A colB colC 1 Flat Street Zip 2 18 xxxx st 950 3 yyyy st 913 4 12 jjjj st Then i wan to mail merge on my document as following Flat 18 ZIP 950 xxxxx st ZIP 913 yyyy ST Flat 12 jjjj st I can easily inset those word "Flat" and "ZIP". But if the cell is blank, it should not t print the word "Flat" and "zip". possible? tap thanks |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access to word Mail merge problem: Requested object is not available | Mailmerge | |||
| Mail merge duplicates return address... | Mailmerge | |||
| How to I get Mail Merge to include Address 3 in a directory? | Mailmerge | |||
| Mail Merge - Multiple Address Records | Mailmerge | |||
| Excel 2003 mail merge problem | Mailmerge | |||
Linear Mode
