Link to home
Start Free TrialLog in
Avatar of Gad SAADIA
Gad SAADIAFlag for France

asked on

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
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

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
Avatar of Gad SAADIA

ASKER

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
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
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
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
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
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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
Excellent solution
Thank you so much Teylyn
Is was so helpful