Solved

mailmerge Word/Excel with image

Posted on 2011-02-13
11
220 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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 500 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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

615 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