Solved

Word/Excel Mail Merge with Photos

Posted on 2014-04-19
8
6,936 Views
Last Modified: 2016-09-10
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.
0
Comment
Question by:Patrick O'Dea
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 250 total points
ID: 40010644
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
 

Author Comment

by:Patrick O'Dea
ID: 40010736
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
 
LVL 15

Assisted Solution

by:DrTribos
DrTribos earned 250 total points
ID: 40010887
+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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:Patrick O'Dea
ID: 40011015
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
 
LVL 15

Expert Comment

by:DrTribos
ID: 40011042
Yes. As long as you give it a valid file name. I think include picture uses a double slash, need to check.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 40011635
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
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 40011638
Thanks, but it's disappointing because the solution  was in your hands with a few keystrokes.
0
 

Expert Comment

by:Seth Portra
ID: 41793088
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question