Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2012, 04:42 AM
macropod's Avatar
macropod macropod is offline Inserting a clipart to mail merge Windows 7 64bit Inserting a clipart to mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

In that case, if all your images are in 'C:\Documents and Settings\MANAGER\Desktop\New folder', In Excel you'd use:
C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx
and, in the Word document, the third version of the field coding from my last post:


{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} {INCLUDEPICTURE {IF TRUE ĢImageģ} \d}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-01-2012, 05:17 AM
dazwm dazwm is offline Inserting a clipart to mail merge Windows XP Inserting a clipart to mail merge Office 2007
Advanced Beginner
Inserting a clipart to mail merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Ok I think I got the first part but not the second 'and, in the Word document, the third version of the field coding from my last post:
{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} {INCLUDEPICTURE {IF TRUE ĢImageģ} \d}}' how do I put this in using the mail merge wizard?
Reply With Quote
  #3  
Old 06-01-2012, 05:28 AM
macropod's Avatar
macropod macropod is offline Inserting a clipart to mail merge Windows 7 64bit Inserting a clipart to mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by dazwm View Post
Ok I think I got the first part but not the second 'and, in the Word document, the third version of the field coding from my last post:
{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} {INCLUDEPICTURE {IF TRUE ĢImageģ} \d}}' how do I put this in using the mail merge wizard?
For the most part you don't. See the note in post 6 above. Except for the ĢImageģ fields, which you can input via the mail merge wizard, the rest is created manually. For example selecte the destination point and press Ctrl-F9 three times. You'll get three nested fields, thus '{ { { } } }'. Fill these in with the text so that you end up with:
{IF {INCLUDEPICTURE {IF TRUE } \d} }
After the 'IF TRUE ' use the mail merge wizard to insert the first ĢImageģ field. you should now have:
{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} }
Now move the cursor to the left of the last '}' and press Ctrl-F9 twice more, so that you get:
{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} { { } }}
Complete the in-filling as already described.
Note: At a minimum you should end up with the following spacing in the field code:
{IF {INCLUDEPICTURE {IF TRUE ĢImageģ} \d} {INCLUDEPICTURE {IF TRUE ĢImageģ} \d}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 06-01-2012, 06:00 AM
dazwm dazwm is offline Inserting a clipart to mail merge Windows XP Inserting a clipart to mail merge Office 2007
Advanced Beginner
Inserting a clipart to mail merge
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

I have put a part number into excel in column A then in column B put C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx

I shut down then opened word and did the merge but when I went to print preview there was no picture just the wording C:\Documents and Settings\MANAGER\Desktop\New folder\edp1058.pcx
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a clipart to mail merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Inserting a clipart to mail merge From a beginner: Mail Merge using Windows Mail mhalpern705 Mail Merge 3 12-16-2011 04:58 AM
Inserting a clipart to mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Inserting a clipart to mail merge Inserting pages at the end of a mail merge morten_lysgaard Mail Merge 3 07-25-2011 11:19 PM
Inserting images into mail merge lorraine_hamilton Mail Merge 0 10-19-2009 09:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:52 AM.


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