Adding Photo To Cell For Mail Merge

[dazwm]

Not sure if I am in the right room for this one but here goes. I have a spreadsheet that has data I use for labels with mail merge. As it goes at the moment I open up word select mail merge and it opens the excel file. If I want to insert a small logo for each label where and how do I put the photo? Thanks.

[macropod]

If it's the same image for all labels, simply add it to the label in the Word document.

If it's a different image for each label, your data source will need to include at least the filename for each image. You can then use an INCLUDEPICTURE field as part of the mailmerge setup to import each picture.

[dazwm]

Originally Posted by macropod

If it's the same image for all labels, simply add it to the label in the Word document.

The image is the same. How would i do this? I used the step by step mail merge wizard and there was no mention of inserting image. Thanks.

[macropod]

You simply add the image to the first label. It's not part of the mailmerge process, as such; it's just a normal part of document creation. Then, when you have that label done, choose 'update labels'.

[dazwm]

Ok I am half way there. What I have done with previous labels is record a macro so when I need some labels I just run the macro and it does it all for me. The problem I have is that when I select record the little cassette tape appears and it wont let me resize or move the image. How can I get round this?

[macropod]

There are some things the macro recorder won't record. This is one of them. In any event, once it's set up, you shouldn't need a macro.

[dazwm]

Originally Posted by macropod

There are some things the macro recorder won't record. This is one of them. In any event, once it's set up, you shouldn't need a macro.

I do need a macro - I think!. The layout will be the same everytime but the data on the Excel file will change each time. Once I have the excel file I open a word doc and run the code and it does it all.

But there is nothing I can do about the image then? I notice an image cannot be entered into a cell like text or a number otherwise that could be my answer!

[macropod]

It doesn't matter that the data change. That's the whole point of a mailmerge. Simply re-run it by opening the file and clicking the 'Finish' button and you'll get a new output.

[dazwm]

So I would setup a mail merge as I have been doing and insert the image then save as what? Then each time I open it just look for the excel document and the layout wil be the same.

[macropod]

Once you've set up the mailmerge and you save the mailmerge main document, it will automatically look for its data source every time you open it. All you need to do is to answer 'Yes' to the initial mailmerge prompt, then click 'Finish' to generate a new output.

[dazwm]

Ok I have set up a mail merge with the excel file as a database in the style I need. I saved it as a word template and shutdown. I changed the data in the excel file reopened the word template and said 'yes' but it had all the data from the original template. What am I doing wrong please?

[macropod]

Hi dazwm,

You didn't need to save it as a template - mailmerge main documents are meant to be used as documents. Did you execute the merge afresh by clicking the 'Finish' button?

[dazwm]

Thanks macropod it is now ok but one slight problem. Where I have added a logo to the mail merge it prints them on every label on the sheet. If I have 18 labels to a sheet and I need to print 4 labels for example taken from the excel database the logo is printed on the other 14 which is a big ink waste over time. How can I get round this please?

[macropod]

Hi dazwm,

The simplest remedy is to merge to a new file and, if you have unused cells left over of the last page, delete those rows before printing.