mail merge, suppress auto next record

mail merge, suppress auto next record

Post by ZG1he » Sun, 27 Apr 2008 10:50:00


I've created a mail merge that outputs a number of labels for each record
from an excel spreadsheet. the number is taken from a field in the
spreadsheet and is different for each record. to do this I use "IF"s and
then do the "NEXT" record myself. it works great except of course that Word
automatically inserts a next record at the start of each page. I can't have
that because at the page break I might be right in the middle of printing out
8 labels of the same record and then Word forces a new record!

any ideas?

thanks.
 
 
 

mail merge, suppress auto next record

Post by Doug Robbi » Sun, 27 Apr 2008 11:01:42

You may be able to do it if you use a catalog (or in Word XP and later, it
is called directory) type mail merge main document. You would however only
put one row of labels in that document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 
 
 

mail merge, suppress auto next record

Post by juser_bogu » Sun, 27 Apr 2008 11:56:58

I did try that.... I started a "directory" and then set up a table,
each cell was a label. even with the directory it seems to always do
a next record after the page break.

dmaz

On Apr 25, 9:01 pm, "Doug Robbins - Word MVP"
 
 
 

mail merge, suppress auto next record

Post by Doug Robbi » Sun, 27 Apr 2008 18:07:16

Thinking about it again now, that would be right, and I guess it means that
there is no way (when using mailmerge) to do what you want. It probably can
be done using a macro however.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP