I have a data validation drop down list with a list of over 100 names. When a name is selected from the list, data populates in a table below that displays a snapshot of weekly productivity for that individual. I want to create a vba macro to do the following: For each name in the range that populates the drop down list, create an image of a specific range of cells and save that image as a file (.jpg or .png are both OK) into a folder.
The ultimate goal is to use mail merge to automate individual e-mails that contain these images, so I'm thinking naming each file as the person's e-mail address is probably a good idea as well.
The ultimate goal is to use mail merge to automate individual e-mails that contain these images, so I'm thinking naming each file as the person's e-mail address is probably a good idea as well.
- The worksheet that contains the range of names for the drop down list is "Sheet2" and the names are in column A.
- The drop-down list and data table are in a worksheet named, "Coder Scorecard."
- The drop down list is located in cell E1
- The range of cells for the image is C1:J17
