I need a mail merge to be created from an excel spreadsheet. There will be a lot of rows, but the example to start only has 3. There are 5-6 merge fields per row.
Brand image (column B)
Pattern # (column A)
Couch image (column C)
Drapery image (column D) --> sometimes like in row 4 there will not be an image for this one.
Large Image (column E)
Hyperlink URL (column F)
At the end of the merge, the file should look like the example PDF attached.
The images are also in the attached file corresponding to the spreadsheet.
Each row should create an individual PDF with the file name based on column G.
The page length should be about 22 inches long by 8.5 inches wide.
See my word document attached for reference.
The example word document and PDF output is based on row 1.
January 1, 2018
I am looking for a mix of experience and value