?
Solved

mailmerge Word/Excel with image

Posted on 2011-02-13
11
Medium Priority
?
246 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:gadsad
  • 6
  • 5
11 Comments
 
LVL 50
ID: 34885870
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
 

Author Comment

by:gadsad
ID: 34950396
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
 
LVL 50
ID: 34950480
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

Author Comment

by:gadsad
ID: 34950543
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
 
LVL 50
ID: 34950615
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
 

Author Comment

by:gadsad
ID: 34989525
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
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 34989790
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
 

Author Comment

by:gadsad
ID: 34990398
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
 
LVL 50
ID: 34991026
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
 

Author Closing Comment

by:gadsad
ID: 34995751
Excellent solution
Thank you so much Teylyn
Is was so helpful
0
 
LVL 50
ID: 34995785
Merci beaucoup!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

601 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