Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
urgent mail merge with different pictures problem
Hi,
I am trying to make product labels with individual pictures in Word (again lol). I have done this before with the help of this forum and so am familiar with the issues and workarounds that are common and are dealt with on Graham M's helpful site. I am using the method of {INCLUDEPICTURE {MERGEFIELD "PhotoPath" }\*MERGEFORMAT} as the picture and Photopath as a column in my excel spreadsheet that contains the rest of the product info. The field contains the path is in exactly the following format: C:\\Documents and Settings\\oliver.merge\\My Documents\\PWC photo labels\\pics\\PWC_FRS010.jpg Problem is that this time I just cant get the pictures to appear where they should. I have 10 labels to a page, and on my original excel file the first picture is missing, so would be C:\\Documents and Settings\\oliver.merge\\My Documents\\PWC photo labels\\pics\\.jpg This first file being missing seemed to cause word to pick a default image, which happens to be a picture of a telephone I took ages ago. So this phone image appeared in the first label, followed by the rest of the labels in the correct place. So far so good, I then decided I want to leave out the items with no photo, and firstly tried deselecting them in the select merge recipients thing. This had the effect of updating the text elements correctly, but leaving the pictures as they are, keeping in the default phone picture and so having the pics lined up against the wrong products. I tried select all F9 and merging to a new document, I get various incorrect results such as all pictures being the default phone one, all pictures disappearing and all records changing to be the first one. I see when pressing alt F9 that its changed the mergefield part in the INCLUDEPICTURE command to an absolute path and so tried starting again with a brand new INCLUDEPICTURE command with the mergefield photopath put back in. No good, same problem. I then tried making a brand new excel workbook with all products that are missing pictures taken out and merged from that instead. No good, exactly the same problem, still has the default images in where they would be if I merged from the original data. I have tried deleting the INCLUDEPICTURE thing and inserting a brand new one and its just ignoring me and putting the default phone picture in again. Im completely baffled, in fact I cant even find where the phone picture is on my harddrive to see what happens if I delete it so I have no idea where how or why word is finding it. As I say, I managed to get this to work a few months ago but now am completely stuck. The only difference is I am now using WORD 2003 instead of 2000. please please help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent - Big printing problem | Microsoft Word Help | |||
MAil Merge with Pictures | Mailmerge | |||
Urgent: Word Document Problem | Microsoft Word Help | |||
It urgent please help - pictures and objects grouping | Microsoft Word Help | |||
mail merge with pictures | Mailmerge |