Hello all,
I've been looking into Mail Merges from Access through VBA and after much messing got a basic mail merge working, but I want to be able to do a bit more with it, the only problem is I'm not sure if a mail merge can do what I want or whether I should be looking in another direction. Anyway I'll describe the problem and if anyone can point me in the right direction, thanks.
The merge in question is a report of Product coverage in Magazines, an access database stores the magazine name, circulation and a UNC link + filename where jpg pictures can be found.
As each Magazine article can be x number of pages long and a UNC path and filename are stored in Access allowing jpeg files to be inserted into the mail merge for each page of an article, is there any way I can change the header for every page after the first one so that it displays "continued".
The template code in word is posted below.
{MERGEFIELD "tbl_Media_CompanyName"}
{MERGEFIELD tbl_Coverage_Cover_Date \@"MMMM YYYY"}
Circulation - {MERGEFIELD Circulation}
{INCLUDEPICTURE "{MERGEFIELD "PictureLocation"}"}
Also is it possible to create a Table of Contents - I realise I could promote the {MERGEFIELD "tbl_Media_CompanyName"} as a Outline Header 1 in the template, but this will show several entries for each multi page article when all I want is the first page of an article to be referenced.
Thanks again for being bothered to read this far.
Jon
I've been looking into Mail Merges from Access through VBA and after much messing got a basic mail merge working, but I want to be able to do a bit more with it, the only problem is I'm not sure if a mail merge can do what I want or whether I should be looking in another direction. Anyway I'll describe the problem and if anyone can point me in the right direction, thanks.
The merge in question is a report of Product coverage in Magazines, an access database stores the magazine name, circulation and a UNC link + filename where jpg pictures can be found.
As each Magazine article can be x number of pages long and a UNC path and filename are stored in Access allowing jpeg files to be inserted into the mail merge for each page of an article, is there any way I can change the header for every page after the first one so that it displays "continued".
The template code in word is posted below.
{MERGEFIELD "tbl_Media_CompanyName"}
{MERGEFIELD tbl_Coverage_Cover_Date \@"MMMM YYYY"}
Circulation - {MERGEFIELD Circulation}
{INCLUDEPICTURE "{MERGEFIELD "PictureLocation"}"}
Also is it possible to create a Table of Contents - I realise I could promote the {MERGEFIELD "tbl_Media_CompanyName"} as a Outline Header 1 in the template, but this will show several entries for each multi page article when all I want is the first page of an article to be referenced.
Thanks again for being bothered to read this far.
Jon