View Single Post
 
Old 04-20-2011, 10:58 AM
Sonia Sosa Sonia Sosa is offline Windows Vista Office 2003
Novice
 
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