Thread: [Solved] SQL MailMerge Labels
View Single Post
 
Old 05-10-2013, 06:44 AM
Mark J Rees Mark J Rees is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: May 2011
Posts: 4
Mark J Rees is on a distinguished road
Question SQL MailMerge Labels

Hi All,

I'm in a bit of a pickle, i have set up a mailmerge from our SQL database for a few years now and all is fine.
I've now decided to create a labels template in word and hook it up to the SQL database the same way, one problem i have is when i select the recipients to merge on the label i only get the first client i selected and no others.

I have four labels to a page, i'm using the <NEXT> tag at the end of each record (although if i remove this i still get the same issue).
The merge template has a direct link to SQL, no .xls or .mdb as an intermediate (just a sql query).
I'm using the recommended MailMerge Wizard.

So all in all i'm just trying to merge four different clients per page but i get one.

Any help will be appreciated.
Reply With Quote