Word/Excel Mail Merge with Photos

Hi,

I am researching the best way to do a mail merge with word/excel AND jpg's.

What do the experts think?

I have found some stuff on the web about this but I am wondering is it being overcomplicated.

Can anyone point me towards a neat solution.
Patrick O'DeaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
Presumably the picture locations are in a column of the Excel sheet that is the datasource.

If that is the case, you need to embed the MERGEFIELD for that column into an INCLUDEPICTURE field.

You might have a merge field on the document that looks like <<Picture>> where Picture is the column header in the Excel sheet.
Using the Alt+F9 toggle will cause the field codes to show so that you will now see
{ MERGEFIELD Picture }.

Select the field and use Ctrl+F9 to add a pair of field delimiters around it so that it now looks like this:
{{ MERGEFIELD Picture }}
 (Don't type { or } separately. They are not the same thing).

Type the field name  INCLUDEPICTURE  after the first field delimiter so  that it now looks like this:
{ INCLUDEPICTURE  { MERGEFIELD Picture } }

That should do it, though you might like to hide the field codes by using Alt+F9 again. Note that the field will now not be visible as because the MERGEFIELD is now  nested inside an INCLUDEPICTURE field.
0
 
Patrick O'DeaAuthor Commented:
Thanks for suggestion, I will try it later.

As a matter of interest, would a merge of 2,000 pages be problematic (1 jpg per page)??
0
 
DrTribosConnect With a Mentor Commented:
+1 Graham, use IncludePicture fields.

You can also unlink the pictures so they become embedded in your document... now with 2000 pictures I think you would want to use Grahams approach then Save then experiment with unlinking. To unlink all fields:

Ctrl + A  (select all)
Ctrl + Shift + F9   (unlink)

Warning: if you have other fields in your document they might break.

I'd suggest making sure your file size for each image was small before unlinking - Word tends to bog down with large file sizes...

There are lots of programs for processing images, I support IrfanView.

HTH
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Patrick O'DeaAuthor Commented:
Thanks folks,

Could I finetune my question...

My excel sheet will have a heading in column A call "PersonID" which will have values like "P100" , "P101", "P102" ... etc.

There will be a jpg file in the same folder call P100.jpg , P101,jpg.  (pictures of individuals).
I.e. there will NO jpg's in the actual sheet.

Will you suggested approach work in the above scenario?
0
 
DrTribosCommented:
Yes. As long as you give it a valid file name. I think include picture uses a double slash, need to check.
0
 
Patrick O'DeaAuthor Commented:
Thanks folks,

I experimented for some time with your suggestions and a mis-behaving "Microsoft Word"

In the end I paid for (not my money) the OnMerge utility which made life easy!
0
 
GrahamSkanRetiredCommented:
Thanks, but it's disappointing because the solution  was in your hands with a few keystrokes.
0
 
Seth PortraCommented:
Graham,

I have been trying to use your solutions, but cannot get the IncludePicture to recognize the MERGEFIELD as a web address and update with the addresses from the spreadsheet.  When I remove the merge and paste the addresses in it does import the image.  Does the image need to be stored locally?  It seems like this method should work.  Any insights greatly appreciated.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.