Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using mail merge to complete customer update form
I have been cracking my head to merge customer update form with
existing data. Example as follows: Excel rows contains the following information: Customer number, customer name, business purpose (billing or delivery), contact, email, address What I would like to do is to merge the above data in the customer update form (MS Word). The problem I have is that I have multiple customer with similar customer number and name but different business purpose, contact, email and address. Can anyone out there help me? Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using mail merge to complete customer update form
Hi Paul,
Assuming you want to group the data by customer number or name, for example, you could use Word's Catalogue/Directory Mailmerge facility is (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "Paul" wrote in message ... I have been cracking my head to merge customer update form with existing data. Example as follows: Excel rows contains the following information: Customer number, customer name, business purpose (billing or delivery), contact, email, address What I would like to do is to merge the above data in the customer update form (MS Word). The problem I have is that I have multiple customer with similar customer number and name but different business purpose, contact, email and address. Can anyone out there help me? Thanks. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using mail merge to complete customer update form
See the following page of fellow MVP Graham Mayor's website:
http://www.gmayor.com/ManyToOne.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, originally posted via msnews.microsoft.com "Paul" wrote in message ... I have been cracking my head to merge customer update form with existing data. Example as follows: Excel rows contains the following information: Customer number, customer name, business purpose (billing or delivery), contact, email, address What I would like to do is to merge the above data in the customer update form (MS Word). The problem I have is that I have multiple customer with similar customer number and name but different business purpose, contact, email and address. Can anyone out there help me? Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge, mulitple filed to one customer | Microsoft Word Help | |||
How Can I mail merge a customer name and bought product list? | Mailmerge | |||
Creating a form in Word and using Mail Merge to Complete | New Users | |||
Mail Merge with multiple rows for each customer? | Mailmerge | |||
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 | Mailmerge |