I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template.
So far I have written code to open the template form but am having difficutlites populating the employee number into one of the fields. The remaining fields are formulas tied to that employee number. I would like to do this for all 400+ records I have and save them as PDF's.