Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge two rows into one, then merge into mailer?
I'm working with an excell sheet that due to seperate parcel numbers is
showing duplicate/multiply addresses for the same company (which is why there are the duplicate addresses). I'm trying to find if there is a way to merge or combine the seperate parcel numbers into one so as to eliminate the duplication and create one address for the mailer showing the various parcel numbers that pertain to the addressee? Example: Parcel # Name Addressess City State 503.56.001H TV LAND PO Box 1111 Mesa AZ 503.56.001I TV LAND PO Box 1111 Mesa AZ I need the Parcel #'s to show as one (i.e. 503.56.001H, 503.56.001I) and then delete the duplicate or multiply rows that shows the same land owner etc. I can create a merge formula using the &"" formula however; I have over 4,000 names and to do this individually will take hours if not days. Does anybody know a short cut or a Merge Format in Word that will do what I need it to do? We only want one mailer to go to each property owner not multiplies just because they own more than one piece of property. Thanks for any help or advise. Tava |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge two rows into one, then merge into mailer?
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "tavat" wrote in message ... I'm working with an excell sheet that due to seperate parcel numbers is showing duplicate/multiply addresses for the same company (which is why there are the duplicate addresses). I'm trying to find if there is a way to merge or combine the seperate parcel numbers into one so as to eliminate the duplication and create one address for the mailer showing the various parcel numbers that pertain to the addressee? Example: Parcel # Name Addressess City State 503.56.001H TV LAND PO Box 1111 Mesa AZ 503.56.001I TV LAND PO Box 1111 Mesa AZ I need the Parcel #'s to show as one (i.e. 503.56.001H, 503.56.001I) and then delete the duplicate or multiply rows that shows the same land owner etc. I can create a merge formula using the &"" formula however; I have over 4,000 names and to do this individually will take hours if not days. Does anybody know a short cut or a Merge Format in Word that will do what I need it to do? We only want one mailer to go to each property owner not multiplies just because they own more than one piece of property. Thanks for any help or advise. Tava |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge two rows into one, then merge into mailer?
Doug,
Thanks for the links and help. I will read through and see if this will work. "Doug Robbins - Word MVP" wrote: Sounds like you are probably trying to perform a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "tavat" wrote in message ... I'm working with an excell sheet that due to seperate parcel numbers is showing duplicate/multiply addresses for the same company (which is why there are the duplicate addresses). I'm trying to find if there is a way to merge or combine the seperate parcel numbers into one so as to eliminate the duplication and create one address for the mailer showing the various parcel numbers that pertain to the addressee? Example: Parcel # Name Addressess City State 503.56.001H TV LAND PO Box 1111 Mesa AZ 503.56.001I TV LAND PO Box 1111 Mesa AZ I need the Parcel #'s to show as one (i.e. 503.56.001H, 503.56.001I) and then delete the duplicate or multiply rows that shows the same land owner etc. I can create a merge formula using the &"" formula however; I have over 4,000 names and to do this individually will take hours if not days. Does anybody know a short cut or a Merge Format in Word that will do what I need it to do? We only want one mailer to go to each property owner not multiplies just because they own more than one piece of property. Thanks for any help or advise. Tava |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge columns without merging rows? | Tables | |||
A Merge letter requiring one or more different different mege letters depending on entry in fields | Microsoft Word Help | |||
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? | Tables | |||
How do I print several rows on one merge document | Mailmerge | |||
Mail Merge with duplicate rows of data | Mailmerge |