If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merging Catalog into an existing Word Table
I have access data which I want to mail merge into an existing invoice
template used in my company. Basically, I want all the records that have the same customer invoice number to go on the same invoice sheet Using mail merge with a catlog and some MERGESEQ and IF statements... {if {mergesec}="1" " PAGE BREAK {mergefield proj_#} {mergefield proj_man} {mergefield WR} {mergefield Company} {mergfield Address} {mergefield Customer_invoice#}"}{set invoice1{mergefield customer invoice#}} {if{invoice1}{invoice2}" PAGE BREAK {mergefield proj_#} {mergefield proj_man} {mergefield WR} {mergefield Company} {mergfield Address} {mergefield Customer_invoice#} {mergefield details}" "{mergefield details}"}{set invoice2{mergefield customer_invoice#}} ...I have managed to get the data to collate accordingly in a blank document. but I want to get it to mail merge into this existing invoice template. - I have tried using form letters, but this just prints a new invoice for each individual job, so instead of one form, I have 5!. Any ideas on how I can manipulate the coding etc to utilise form letters or using the catalog method into an exisiting form? Cheers --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Mail Merging Catalog into an existing Word Table
See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "DKING " wrote in message news I have access data which I want to mail merge into an existing invoice template used in my company. Basically, I want all the records that have the same customer invoice number to go on the same invoice sheet Using mail merge with a catlog and some MERGESEQ and IF statements... {if {mergesec}="1" " PAGE BREAK {mergefield proj_#} {mergefield proj_man} {mergefield WR} {mergefield Company} {mergfield Address} {mergefield Customer_invoice#}"}{set invoice1{mergefield customer invoice#}} {if{invoice1}{invoice2}" PAGE BREAK {mergefield proj_#} {mergefield proj_man} {mergefield WR} {mergefield Company} {mergfield Address} {mergefield Customer_invoice#} {mergefield details}" "{mergefield details}"}{set invoice2{mergefield customer_invoice#}} ..I have managed to get the data to collate accordingly in a blank document. but I want to get it to mail merge into this existing invoice template. - I have tried using form letters, but this just prints a new invoice for each individual job, so instead of one form, I have 5!. Any ideas on how I can manipulate the coding etc to utilise form letters or using the catalog method into an exisiting form? Cheers --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|