Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Novice needs help with cosolidating in mailmerge document
I have a data table which contains multiple records for the same individual.
Is it possible in the mail merge process to send the one individual one letter containing different types of information? For instance, I'd like to send a mail merge letter to Mr. X containing purchase information he has made throughout the year. How do I go about making sure Word does not create multiple merged letters for Mr. X? Confusing? Hopefully not. Thanks in advance for any assistance you may be able to provide. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Novice needs help with cosolidating in mailmerge document
Hi Jae,
See: http://support.microsoft.com/?kbid=211303 for the principles. However, if your data source is an Excel file, I'd suggest basing your code on the following (which will work the same with other data sources too) for the second example: {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" {QUOTE 12}}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "} ENTER or {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" " ----------------------------Page Break-------------------------------- "}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "}ENTER With the field coded provided in all the examples in the KB article, an extra line is inserted between records for the same location when using an Excel workbook as the data source. -- Cheers macropod [MVP - Microsoft Word] "Jae" wrote in message news I have a data table which contains multiple records for the same individual. Is it possible in the mail merge process to send the one individual one letter containing different types of information? For instance, I'd like to send a mail merge letter to Mr. X containing purchase information he has made throughout the year. How do I go about making sure Word does not create multiple merged letters for Mr. X? Confusing? Hopefully not. Thanks in advance for any assistance you may be able to provide. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Novice needs help with cosolidating in mailmerge document
Thanks for your response. I keyed in your example, but unfortunately I
still can't get it to consolidate the employee/sales information onto one letter. What do you think I could be wrong? I'm using Word 2003, creating a mail merge directory. Thanks again. Jae "macropod" wrote: Hi Jae, See: http://support.microsoft.com/?kbid=211303 for the principles. However, if your data source is an Excel file, I'd suggest basing your code on the following (which will work the same with other data sources too) for the second example: {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" {QUOTE 12}}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "} ENTER or {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" " ----------------------------Page Break-------------------------------- "}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "}ENTER With the field coded provided in all the examples in the KB article, an extra line is inserted between records for the same location when using an Excel workbook as the data source. -- Cheers macropod [MVP - Microsoft Word] "Jae" wrote in message news I have a data table which contains multiple records for the same individual. Is it possible in the mail merge process to send the one individual one letter containing different types of information? For instance, I'd like to send a mail merge letter to Mr. X containing purchase information he has made throughout the year. How do I go about making sure Word does not create multiple merged letters for Mr. X? Confusing? Hopefully not. Thanks in advance for any assistance you may be able to provide. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Novice needs help with cosolidating in mailmerge document
Did you use Ctrl+F9 to insert each pair of field delimiters {}?
You might also take a look at : http://cornell.veplan.net/article.aspx?&a=3815 as it gives an explanation of the function of each part of the field construction. -- 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 "Jae" wrote in message ... Thanks for your response. I keyed in your example, but unfortunately I still can't get it to consolidate the employee/sales information onto one letter. What do you think I could be wrong? I'm using Word 2003, creating a mail merge directory. Thanks again. Jae "macropod" wrote: Hi Jae, See: http://support.microsoft.com/?kbid=211303 for the principles. However, if your data source is an Excel file, I'd suggest basing your code on the following (which will work the same with other data sources too) for the second example: {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" {QUOTE 12}}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "} ENTER or {QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" " ----------------------------Page Break-------------------------------- "}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER ENTER "}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER "}ENTER With the field coded provided in all the examples in the KB article, an extra line is inserted between records for the same location when using an Excel workbook as the data source. -- Cheers macropod [MVP - Microsoft Word] "Jae" wrote in message news I have a data table which contains multiple records for the same individual. Is it possible in the mail merge process to send the one individual one letter containing different types of information? For instance, I'd like to send a mail merge letter to Mr. X containing purchase information he has made throughout the year. How do I go about making sure Word does not create multiple merged letters for Mr. X? Confusing? Hopefully not. Thanks in advance for any assistance you may be able to provide. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I mailmerge a publisher document with a word document? | Mailmerge | |||
mailmerge document | Mailmerge | |||
Are tools available to easily design tables for a novice? | Tables | |||
Protect mailmerge document | Mailmerge | |||
Barcode in Mailmerge document | Mailmerge |