Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-01-2012, 06:02 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default Adding Photo To Cell For Mail Merge

Not sure if I am in the right room for this one but here goes. I have a spreadsheet that has data I use for labels with mail merge. As it goes at the moment I open up word select mail merge and it opens the excel file. If I want to insert a small logo for each label where and how do I put the photo? Thanks.
Reply With Quote
  #2  
Old 05-01-2012, 06:42 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If it's the same image for all labels, simply add it to the label in the Word document.

If it's a different image for each label, your data source will need to include at least the filename for each image. You can then use an INCLUDEPICTURE field as part of the mailmerge setup to import each picture.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-01-2012, 06:49 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
If it's the same image for all labels, simply add it to the label in the Word document.
The image is the same. How would i do this? I used the step by step mail merge wizard and there was no mention of inserting image. Thanks.
Reply With Quote
  #4  
Old 05-01-2012, 06:54 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You simply add the image to the first label. It's not part of the mailmerge process, as such; it's just a normal part of document creation. Then, when you have that label done, choose 'update labels'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-01-2012, 06:59 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Ok I am half way there. What I have done with previous labels is record a macro so when I need some labels I just run the macro and it does it all for me. The problem I have is that when I select record the little cassette tape appears and it wont let me resize or move the image. How can I get round this?
Reply With Quote
  #6  
Old 05-01-2012, 07:18 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There are some things the macro recorder won't record. This is one of them. In any event, once it's set up, you shouldn't need a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-01-2012, 07:25 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
There are some things the macro recorder won't record. This is one of them. In any event, once it's set up, you shouldn't need a macro.
I do need a macro - I think!. The layout will be the same everytime but the data on the Excel file will change each time. Once I have the excel file I open a word doc and run the code and it does it all.

But there is nothing I can do about the image then? I notice an image cannot be entered into a cell like text or a number otherwise that could be my answer!
Reply With Quote
  #8  
Old 05-01-2012, 07:28 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It doesn't matter that the data change. That's the whole point of a mailmerge. Simply re-run it by opening the file and clicking the 'Finish' button and you'll get a new output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 05-01-2012, 07:33 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

So I would setup a mail merge as I have been doing and insert the image then save as what? Then each time I open it just look for the excel document and the layout wil be the same.
Reply With Quote
  #10  
Old 05-01-2012, 07:49 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Once you've set up the mailmerge and you save the mailmerge main document, it will automatically look for its data source every time you open it. All you need to do is to answer 'Yes' to the initial mailmerge prompt, then click 'Finish' to generate a new output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 05-01-2012, 09:39 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Ok I have set up a mail merge with the excel file as a database in the style I need. I saved it as a word template and shutdown. I changed the data in the excel file reopened the word template and said 'yes' but it had all the data from the original template. What am I doing wrong please?
Reply With Quote
  #12  
Old 05-01-2012, 03:29 PM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dazwm,

You didn't need to save it as a template - mailmerge main documents are meant to be used as documents. Did you execute the merge afresh by clicking the 'Finish' button?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 05-03-2012, 12:52 AM
dazwm dazwm is offline Adding Photo To Cell For Mail Merge Windows XP Adding Photo To Cell For Mail Merge Office 2007
Advanced Beginner
Adding Photo To Cell For Mail Merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Thanks macropod it is now ok but one slight problem. Where I have added a logo to the mail merge it prints them on every label on the sheet. If I have 18 labels to a sheet and I need to print 4 labels for example taken from the excel database the logo is printed on the other 14 which is a big ink waste over time. How can I get round this please?
Reply With Quote
  #14  
Old 05-03-2012, 02:35 AM
macropod's Avatar
macropod macropod is offline Adding Photo To Cell For Mail Merge Windows 7 64bit Adding Photo To Cell For Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi dazwm,

The simplest remedy is to merge to a new file and, if you have unused cells left over of the last page, delete those rows before printing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Filters adding condition not originally specified bobcharest Mail Merge 11 06-13-2014 11:03 PM
Adding Photo To Cell For Mail Merge Adding cell value Novice Excel 1 07-26-2011 11:13 AM
Adding Photo To Cell For Mail Merge Adding Image into a excel cell and adding a hyperlink to the image saravananiyyanar Excel 3 05-04-2011 08:31 AM
Pasting multiple photos - one photo per cell in a single oepration mccruise Word 0 04-07-2010 04:13 AM
Adding Photo To Cell For Mail Merge Pulbisher website-adding photo slideshow lakeshia Publisher 1 05-20-2008 01:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft