Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Names and address list in Excel-mail merge to Word for labels
I have a spreadsheet with the following column headings
Last1 First1 Last2 First2 Address City State Zip Smith John Jones Mary 123 Main St Anywhere NC 27777 I have the Block Address selected which would make the label John Smith and Mary Jones 123 Main St Anywhere, NC 27777 These labels as well as John and Mary Smith (when spouse has same last name) are coming out fine. The problem is that if any entry on my Excel list is for John Smith ONLY, the label is coming out "The Smith Family". How can I make it come out as John Smith on my Word label? thanks... Dee |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Names and address list in Excel-mail merge to Word for labels
You will not achieve the results you require with the addressblock field.
Use the individual fields - see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm As for the spouse issue, use a conditional field eg something along the lines of { IF{ Mergefield First2 } "" "{ IF{ Mergefield Last1 } { Mergefield Last 2 } "{ Mergefield First1} { Mergefield Last1 } and { Mergefield First2 } { Mergefield Last2}" "{ Mergefield First1 } and { Mergefield First2 } and { Mergefield Last1 }"}" "{ Mergefield First1 } { Mergefield Last1 }" } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org djackola wrote: I have a spreadsheet with the following column headings Last1 First1 Last2 First2 Address City State Zip Smith John Jones Mary 123 Main St Anywhere NC 27777 I have the Block Address selected which would make the label John Smith and Mary Jones 123 Main St Anywhere, NC 27777 These labels as well as John and Mary Smith (when spouse has same last name) are coming out fine. The problem is that if any entry on my Excel list is for John Smith ONLY, the label is coming out "The Smith Family". How can I make it come out as John Smith on my Word label? thanks... Dee |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Names and address list in Excel-mail merge to Word for labels
Hi Dee,
If you don't like the results of the block address, you could insert the fields manually to create the address block exactly as you'd like it. The field code formula below will accomodate the 3 name variations you stipulated. 1. Same Surname "John & Mary Smith" 2. Different Surname "John Smith & Mary Jones" 3. Individual "John Smith" This is the field code formula. You need to create the braces using CTRL+F9 (you can't just copy and paste my text). { MERGEFIELD "First1" } { If { MERGEFIELD "Last2" }="" { MERGEFIELD "Last1" } { If { MERGEFIELD "Last2" }={ MERGEFIELD "Last1" } "& { MERGEFIELD "First2" } { MERGEFIELD "Last1" }" "{ MERGEFIELD "Last1" } & { MERGEFIELD "First2" } { MERGEFIELD "Last2" }"} } Here is the logic, which may help you understand the formula. 1. Insert "First1 " 2. If Last2 is blank, then insert "Last1". 3. If Last2 equals Last1 then insert "& First2 Last1" 4. Else Insert "Last1 & First2 Last2" Hope this helps you out! Kind regards Stuart Sydney, AUSTRALIA "djackola" wrote in message ... I have a spreadsheet with the following column headings Last1 First1 Last2 First2 Address City State Zip Smith John Jones Mary 123 Main St Anywhere NC 27777 I have the Block Address selected which would make the label John Smith and Mary Jones 123 Main St Anywhere, NC 27777 These labels as well as John and Mary Smith (when spouse has same last name) are coming out fine. The problem is that if any entry on my Excel list is for John Smith ONLY, the label is coming out "The Smith Family". How can I make it come out as John Smith on my Word label? thanks... Dee |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with 2 different last names to the same address | Mailmerge | |||
How do I get mail merge address list into Excel spreadsheet? | Mailmerge | |||
inserting new names to existing mail merge list alphabetically | Mailmerge | |||
mail merged in word w/ address list in excel, now cant open excel | Mailmerge | |||
How do I add names to an existing mail merge address book created. | Mailmerge |