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!
06-26-2019, 09:36 AM
Macro to access info from Excel spreadsheet and populate Word doc with text, photos, and captions
Similar Threads
Need macro to fill the values in msword based on the excel sheet info
Windows 10 
Office 2016
Threaded Mode