Solved

mailmerge Word/Excel with image

Posted on 2011-02-13
11
218 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 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