merge template from Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cam - 13 May 2008 16:17 GMT

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 ............................................

Reply to this Message

Robert M. Franz (RMF) - 28 May 2008 20:00 GMT

Hello Cam

> I have a spreadsheet with column for No. (4-numeric digits), model#,
> shipdate and six columns for order#. (Example below)
[quoted text clipped - 7 lines]
> 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

Signature

Reply to this Message