Thread: [Solved] Directory Mail Merge
View Single Post
 
Old 09-09-2016, 07:20 AM
IslandAC IslandAC is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2016
Posts: 1
IslandAC is on a distinguished road
Exclamation Directory Mail Merge

I'm trying to create a mail merge that'll give me the Job Number, Job Name, Job Address and then a list of employees at that job. Each Job needs to be on its own page and if the employee list extends to a 2nd or 3rd page I need the Job Number, Job Name, Job Address to print on the top of the page like it does for the 1st page. This is what I have so far I just can't seem to figure out how to get it to populate the info that I want at the top of the page if it does go to a 2nd page.

{if{mergeseq}="1" "{mergefield job} - {mergefield job_name}
{mergefield address}
"}{SET Job1 {mergefield Job}}
{if{Job1}={Job2}"{mergefield employee_Name}" "
<< I inserted a page break here>>
{mergefield job}-{mergefield job_name}
{mergefield address}

{mergefield employee_name"}{SET Job2{mergefield job}
Reply With Quote