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!

Attached Images

Macro.PNG (10.8 KB, 23 views)

Am I blacklisted? I thought I'd get a reply by now.

As your requirement is vague and you seem to expect someone to program this for you it is not really a surprise that you haven't had a reply.

If you modify your worksheet in line with the description at https://www.gmayor.com/photo_gallery_template.html that might work for you - otherwise it seems that what you are describing is mail merge and that requires a particular syntax for the graphics merge - see https://www.gmayor.com/mail_merge_graphics.htm and https://www.gmayor.com/mail_merge_graphics_addin.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

No, I just don't have experience in VBA and was looking for guidance, not a free code. Not sure why I gave that impression. I'm also new to the forum and still need to get acclimated to the culture that has been developed here. Thanks for the information you provided.

Rearrange your input data into consecutive cells starting in Cell A1. Leaving empty columns makes life so much harder.

Then explore mail merges before attempting a vba method.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia