merge template from Excel?

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I have a spreadsheet with column for No. (4-numeric digits), model#,
shipdate and six columns for order#. (Example below)
For each No., there are 6 order# assigned and will be filled in.
I need to find a function to automate a for each No., I need to print out 6
sheets (8-1/2 x 11) with information that include No., Model and order#. Any
help is greatly appreciated.

No. shipdate model Order#
1001 5/13/08 100 100001 100002 100003 100004 100005
100006
1002 ............................................
 
Hello Cam
I have a spreadsheet with column for No. (4-numeric digits), model#,
shipdate and six columns for order#. (Example below)
For each No., there are 6 order# assigned and will be filled in.
I need to find a function to automate a for each No., I need to print out 6
sheets (8-1/2 x 11) with information that include No., Model and order#. Any
help is greatly appreciated.

No. shipdate model Order#
1001 5/13/08 100 100001 100002 100003 100004 100005
100006
1002 ............................................

that's a straight-forward MailMerge, given a little thought: your main
document must consist of 6 pages, and you just distribute the
MERGEFIELDS accordingly: there's nothing preventing you to repeat the
same MERGEFIELD (i.e., "No.") more than once in the same document (in
your case: on each page).

HTH
Robert
 
Back
Top