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/

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/