I have a blank form - sheet1
I have a list of Name - Sheet2!A1:A15
I would like to automatically print the form once for each name (in this example 15 forms printed)
in Cell A1 I would like the name
so for print #1: print Sheet1 with Name Sheet2!A1 in range Sheet1!A1
for print #2: print Sheet1 with Name Sheet2!A2 in range Sheet1!A1
for print #3: print Sheet1 with Name Sheet2!A3 in range Sheet1!A1
etc...
Possible?
I know - mail merge - but every time I look it up Word is being used.
Bookmarks