Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2013, 09:08 AM
ragesz ragesz is offline IncludePicture does not refresh the pictures Windows 7 64bit IncludePicture does not refresh the pictures Office 2007
Novice
IncludePicture does not refresh the pictures
 
Join Date: Oct 2012
Posts: 14
ragesz is on a distinguished road
Default

Dear All!

I have an excel sheet that contains the file paths of the images and names of them, I want to use in a mail merge. So I use this field for the images:
{ INCLUDEPICTURE { MERGEFIELD "Pict" } \* MERGEFORMAT }
where "Pict" is the column name of my images in the excel sheet.
When I have the separate mail merges, so I can switch between them, the other dynamic texts from the same excel file, like "name" change well. The picture does not. OK, I press Ctr+A then F9. After that, the picture refreshes as well.
But after that, I want close the mail merge, and create one letter from them that contains all mail merges. So if I have 4 rows (4 names, 4 pictures...) in the excel, then I have four mail merges. So I want then in one. I press the appropriate button, and select all mail merges, and the Word generates a Letter that contains all mail merges. The texts like "name" are different in the document, but the pictures are not! Why? Only the first picture is shown in all the 4 cases. Why?
If I change the displayed picture to field code, so pressing Shift+F9, I see the correct INCLUDEPICTURE field with the correct file path. These file paths are different in the 4 cases, and are correct. But when I switch back to show the images not the field codes, only one image (the first) is shown in all 4 cases. Why?
I use Ctr+A then Ctr+Shift+F7 to update all the links manually in the document, but it does not help, nothing happens. So if something is not clear...

Start Mail Merge with Step by Step Wizard has 6 steps. After the 6th step, there is an option to Finish & Merge. Clicking on it and choose Edit Individual Documents, I selected All Merge records, then I pressed OK. The Letter containing all the 4 mail merges has created.
But all shows the same picture, not the individuals!

My excel has two columns: Name and Pict. Name contains names, Pict contains the file pathes of my images. One individual mail merge has one page, so the created Letter has 4 pages because I have 4 items in the excel. And in the Letter, the Name fields are different, but the Pict fields are the same. Clicking on the picture (or press Ctr+A) then press Shift+F9, it toggles to field codes. The field codes are correct, and looks like this:
{ INCLUDEPICTURE c:\images\image1.jpg \* MERGEFORMAT}
On the second page of the Letter, the picture's field code is nearly the same except it has image2.jpg instead of image1.jpg. The third picture has image3.jpg in its field code.
But all pages shows the first picture, not the individuals per pages. Why?

Can anybody help me? Or is it a bug? I tried Word 2010 and 2013 as well... with the same result. I tried English Word and other language Word....

Unbelievable what a damn softwer the Word is... What the hell?
Reply With Quote
  #2  
Old 09-29-2013, 07:09 PM
macropod's Avatar
macropod macropod is offline IncludePicture does not refresh the pictures Windows 7 32bit IncludePicture does not refresh the pictures 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

When embedding a mailmerge field in an INCLUDEPICTURE field for the purpose of merging graphics:
1. the filepaths to the fields need to have the separators expressed as '\\' or '/' instead of the usual '\';
2. the pictures usually won't show until you refresh the fields (eg Ctrl-A, then F9); and
3. even after updating the images, they remain linked to the image files, which can be an issue if you later delete the image or you need to send the merged output to someone else.

The following field construction addresses all three issues (i.e. you don't need to do anything special to the paths, or refresh the fields, and they'll no longer be linked to the source files):
{IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\«Image»"} \d}}
or
{IF {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\{MERGEFIELD Image}"} \d} {INCLUDEPICTURE {IF TRUE "C:\Users\My Document Path\Pictures\{MERGEFIELD Image}"} \d}}
After running a mailmerge coded this way, you'll have the correct, unlinked image for each record.
This form of field construction can be very useful where the filepath for the images is held in the mailmerge data source, in which case you could use:
{IF {INCLUDEPICTURE {IF TRUE "«FilePath»\«Image»"} \d} {INCLUDEPICTURE {IF TRUE "«FilePath»\«Image»"} \d}}
or
{IF {INCLUDEPICTURE {IF TRUE "{MERGEFIELD FilePath}\{MERGEFIELD Image}"} \d} {INCLUDEPICTURE {IF TRUE "{MERGEFIELD FilePath}\{MERGEFIELD Image}"} \d}}

Note: You need a path separator between the filepath mergefield and the image mergefield. If that separator is included in the source data, it can be omitted from the field above construction but leaving it there has no adverse effects either.

If the path data are included with in the image field, you can use:
{IF {INCLUDEPICTURE {IF TRUE «Image»} \d} {INCLUDEPICTURE {IF TRUE «Image»} \d}}
or
{IF {INCLUDEPICTURE {IF TRUE {MERGEFIELD Image}} \d} {INCLUDEPICTURE {IF TRUE {MERGEFIELD Image}} \d}}
For what it's worth, *provided* the path has the separators expressed as '\\' or '/', you can retain the links by omitting the all-encompassing IF test and the images will display correctly without the need to refresh the fields after completing the merge. For example:
{INCLUDEPICTURE {IF TRUE "C:\\Users\\My Document Path\\Pictures\\«Image»"} \d}

Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-08-2015, 04:37 AM
Bloodbike1 Bloodbike1 is offline IncludePicture does not refresh the pictures Windows 7 64bit IncludePicture does not refresh the pictures Office 2013
Novice
 
Join Date: Oct 2015
Posts: 1
Bloodbike1 is on a distinguished road
Default

Hi Guys and Gals.
I have a similar problem. I am trying to create a set if ID cards with a LOGO, Organisation name, card holder name and their photo.
I have followed a you tube clip to use the INCLUDEPICTURE routine which has allowed me to locate a logo within a Label template, add organisation, Name and photo. On completing the merge the labels have the same logo (required), the same Organisation (required), different names on each label (required) BUT it inserts the same member photo on each label rather than a different photo unique to the name.
Any suggestions as to why this happened please.
Cheers for now
Reply With Quote
  #4  
Old 10-08-2015, 04:43 AM
macropod's Avatar
macropod macropod is offline IncludePicture does not refresh the pictures Windows 7 64bit IncludePicture does not refresh the pictures 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

I don't know anything about a YoutTube clip on the matter, but the approach in post #2 addresses your issue comprehensively.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-23-2020, 02:21 AM
Hirenpboy Hirenpboy is offline IncludePicture does not refresh the pictures Windows 10 IncludePicture does not refresh the pictures Office 2019
Novice
 
Join Date: Oct 2020
Posts: 1
Hirenpboy is on a distinguished road
Default

Mr. Paul Edstein

Your suggestion regarding INCLUDEPICTURE has really saved my days of effort and I was really lucky to stumble upon this page. Sir just a single point I would like to mention is that I am not able to resize the included image (it just displays in original size on preview). Your help would really be appreciated.

Thanks

Hiren
Reply With Quote
  #6  
Old 10-23-2020, 03:41 AM
macropod's Avatar
macropod macropod is offline IncludePicture does not refresh the pictures Windows 10 IncludePicture does not refresh the pictures Office 2010
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

See: https://www.msofficeforums.com/151744-post2.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
includepicture, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IncludePicture does not refresh the pictures Using IncludePicture and MailMerge to insert picture Elena Mail Merge 25 02-06-2022 05:35 PM
IncludePicture does not refresh the pictures how to refresh page numbering? danlen Word 1 11-13-2011 11:02 PM
IncludePicture does not refresh the pictures Refresh Skills obietrice Office 1 08-01-2011 05:24 AM
Pivot Table Refresh tpcervelo Excel 0 09-14-2010 06:54 AM
Sound Refresh aeroica PowerPoint 2 06-13-2009 01:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:44 AM.


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