Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Mail Merge to Populate a Form
I currently have set up a Word 2003 Protected Form Template. This is a
certification of training form that the user normally enters the employees badge no., name, and dept no. into a three-column table on the form. The users of the form now want to pull in this information from an Excel 2003 spreadsheet that is kept at the department level into the table on the form. There are 15 rows to the table. Each employee may be listed multiple times in the listing due to different training completed and being recorded for submittal. When output to the merged file, I am getting mixed results but none correctly. When I enter the merge fields as indicated below, it generated about 60 pages with the individual names listed many more times than on the original excel spreadsheet. When I change the field to include: NextMergeformat to both fields it produces only 2 sheets that list the first instance for each employee. There are only 61 rows of record on the excel spread sheet, so it should only generate 3 output pages. I tried entering the row range in the last option of the "Merge to New Document" window as "From 2 To 61" but this is not giving me all the records. What am I doing wrong? Lenny Example: __________________________________________________ ___ ID No. Name Dept. 000001 ID Employee 1 ID NAME 000008 ID Employee 2 ID NAME 000101 ID Employee 3 ID NAME 000001 ID Employee 1 ID NAME |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate from 1 form to another | Microsoft Word Help | |||
Interactive Form - populate one form field to another | Microsoft Word Help | |||
Using Form Filed to populate form | Microsoft Word Help | |||
using mail merge to populate a form letter/document | Mailmerge | |||
How do I use unique fields to populate mail merge data like Word 2 | Mailmerge |