I do not have any experience with Macros and need help.
Based on the attached, I need the macro to do the following:
- Insert the "Text" from the spreadsheet as a paragraph into Word (at a specified location).
- Locate photos from their shared file location based on the "Image #'s" (file name) in the spread sheet, and insert them into the Word document (at a specified location)
- Insert respective "Captions" from the excel file with a preceding "Photo #:". For example, "Photo 1: Outside at the park", "Photo 2: Dogs at the park", etc.
Thanks in advance!