Hi, I have a MailMerge document linked with an EXCEL spreadsheet. On the Merge document, there is a one-cell table set to hold the cover photo for each asset. In the table is the INCLUDEPICTURE command with the file path for each respective photograph.

Once I refresh the fields, the pictures are being inserted properly in the Merged documents. My issue is with the size of the image being pasted in the table. I had several inspectors helping me, all with different cameras, so the image size on all of these photos has the potential to be different. To address this, in the original ACCESS database, I set up a report with a macro to open each file in Microsoft Paint with the intention of resizing each image to a specified size (by number of pixels). Through trial and error, i found a number of pixels that seemed to work for my test image. I merged it and it looked great. I moved on to the next picture, resized it, and then re-ran the merge. The second picture, set to the same number of pixels in length/width, came in at about half the size of the first one.

Does anyone have an idea of what is happening, how to correct it, and/or if there is a better way of approaching this? I have several hundred reports to produce and a tight budget, so editing individual documents is not the route I want to go but I will if need to.

Thanks!