Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-20-2011, 10:58 AM
Sonia Sosa Sonia Sosa is offline Mail Mege Images - Path Correct but Images Repeated Windows Vista Mail Mege Images - Path Correct but Images Repeated Office 2003
Novice
Mail Mege Images - Path Correct but Images Repeated
 
Join Date: Apr 2011
Posts: 5
Sonia Sosa is on a distinguished road
Default Mail Mege Images - Path Correct but Images Repeated

Hi all,



I am putting together a catalog so I have 9 images with their respective descriptions per page.

The problem: Correct Code Same Image Being pulled
Although the code shows that the correct file name is being pulled, when I toggle to show the actual image only the first image (in the Excel sheet) is shown throughout the catalog. For example although the code shows 1,jpg, 2.jpg, 3.jpg, the image shown through the whole catalog is 1.jpg. However all the other text data is being shown correctly. Any ideas on what I am doing wrong?

In order to better understand what I have already accomplished and for others having similar problems. This is what I have fixed:

1. Need double dashes for the path:
{ INCLUDEPICTURE "c:\\CatalogPictures2\\Rings\{MERGEFIELD” “Product_Image_File1} \MERGEFORMAT\d}

2. Code changing on Save or Merge

I would put:
{ INCLUDEPICTURE "c:\\CatalogPictures2\\Rings\{MERGEFIELD” “Product_Image_File1} \MERGEFORMAT\d}

But when I merged or saved it would automatically change to:

{ INCLUDEPICTURE "../../../../../CatalogPictures2/{MERGEFIELD” “Product_Image_File1} \MERGEFORMAT\d}

Note: Both options pull the correct image

Fix: Go to, Tools/Options/General/Mail Options/ and unselect "Update links on Save"

3. Switch between viewing the code and the actual data
The way I was able to accomplish this was by going to:

Fix:
Tools/Options/View/show/
Select "Field Code" (sorry if that is not exact my version is in Spanish) to show code
Unselect to show data (including pictures)

4. Mail Merge for Images does not work in text boxes
Fix: Eliminated the text boxes and used another layout

5. Same data being pulled on for each entry
Only the firt line of the Excel sheet was being pulled.

Fix: In order to overcome this issue after the first entry add {Next Record}for every following entry. Example:

{Next Record} { INCLUDEPICTURE "c:\\CatalogPictures2\{MERGEFIELD” “Product_Image_File1} \MERGEFORMAT\d}

Furthermore, you only have to use the {Next Record}once for each data set. In other word each data set (example 3 per page) consists of:

Image, Title, Description, and Price

Only use {Next Record} before the image (or first item of data set). you do not need to add {Next Record} to the title, description, or price.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Mege Images - Path Correct but Images Repeated Inserted images don't appear terence_laoshi Drawing and Graphics 2 04-14-2011 05:08 AM
Powerpoint images sharon_1985 PowerPoint 0 08-02-2010 11:47 PM
Compressing images Fran PowerPoint 0 10-29-2009 07:18 AM
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:56 PM.


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