mailmerge Word/Excel with image

Hello,

I want to generate this kind of report (see example in attached file)
All data is located in a clean, and structured Excel File
Every Excel line will be a page of output of the report
Total about 100 lines so  a 100 pages report
Pictures are JPEG files (not included in Excel data file)

I was thinking about a mailmerge between Word and Excel (or maybe Powerpoint/Excel) but I dont kwow if the idea is good. Maybe a special report generator tool will be more suitable; any idea ? or comment? any report generator for this kind of work ?

Thank you to all


 Report-Example.pdf
gadsadAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

go back to the tutorial and follow the instructions. The field needs to be

{INCLUDEPICTURE "{IF TRUE "{Mergefield photo}"}" \d }

Pay particular attention to the paragraph

     

If you merely use a an INCLUDEPICTURE field without the additional 'IF TRUE' construction, when you merge, the overwhelming probability is that the images will not be present in the merged document. Alternatively, all the records may display the same image. This is because the fields require updating to display the correct image. It does not mean that the merge hasn't worked.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

You can do this with the { INCLUDEPICTURE } field.

Graham Mayor has an excellent tutorial on this site:

http://www.gmayor.com/mail_merge_graphics.htm

If you get stuck, please pipe up and describe how far you got and what the problem is.

cheers, teylyn
0
 
gadsadAuthor Commented:
Do you think Word 2007 is a good tool for mailmerge? I have been told that Publisher 2010 is better that word for this mailmerge
Any idea?
Thank you
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

I've never done a mail merge with Publisher, so I can't say. What reasons were you given to prefer Publisher over Word?

I've done gazillions of mail merges with Word, though. If you can get the layout organised in Word, there is no reason to use Publisher.

Has your initial question been answered?

cheers, teylyn
0
 
gadsadAuthor Commented:
Thank you for your answer
Yes The initial question has been answered, I just have to do the mailmerge with the image! (I will do it this week and net you know

You have seen the layout, do you think it is feasible sith Word?

Thanks again
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You can build the tables in Word and have the mail merge fields sit in the table. Don't see why it should not work.

cheers, teylyn
0
 
gadsadAuthor Commented:
I use the following formula:

{INCLUDEPICTURE "{MERGEFIELD photo }" \d}

where photo is an Excel column fields with label like:
c:\photos\image1.jpg
c:\photos\image2.jpg
ect...

When I run the mailmerge instead of seing the picture I see a blank space with a lettre RED SIGN at the upper left corner

Any idea what am I doing wrong?

Thanks
0
 
gadsadAuthor Commented:
Hello teylyn

Thank YOu !!
It works !!!!!! the IF TRUE was like magic!

Another question if I can
When using a regular filed in my mailmerge,
in Excel it display €100,000.00 (money format) in the mail merge word document it appears as 100000 (with no formatting) and I do not have the option (right click) with the "format menu"
How do I do that it appears as €100,000.00 ?
Thank you so much again
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Ah, glad to read that.

>> Another question if I can

You should really open a new question, because this is a completely different issue. Hint: use the number formatting switch

{ MERGEFIELD MyNumber \# "€,0.00" }

cheers, teylyn
0
 
gadsadAuthor Commented:
Excellent solution
Thank you so much Teylyn
Is was so helpful
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Merci beaucoup!
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.