View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Robert_L_Ross Robert_L_Ross is offline
external usenet poster
 
Posts: 15
Default Mail merge of excel fields

This doesn't work for me...
Grapic files are .jpg's and saved to c:\graphics.

I have a word doc...I've added a text box over a picture, then done the
following in the text box:
Ctrl+f9 (got the braces {})
typed:
INCLUDEPICTURE "C:\\GRAPHICS\\
Ctrl+f9 (got the 2nd set of braces{})
typed:
MERGEFIELD PIC
used the right arrow to get outside of the first set of braces
typed:
..jpg"

My final statement looks like this:
{INCLUDEPICTURE "C:\\GRAPHICS\\{MERGEFIELD PIC}.JPG"}

The Pic field on my Excel mail merge record file contains just the file name
I want to bring in - WomanDLPicLg or ManDLPicLg.

When I leave the field, I can see it when I toggle the field codes on, but
when they are off I don't see the field.

I save the document, then merge to a new document and get an error:
"Word found locked fields during the update. Word cannot update locked
fields."

Any idea what I'm doing wrong?

Thanks guys (and ladies)!

"Doug Robbins" wrote:

See the "Graphics on Labels" item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/graphics_on_labels.htm

You will also need to see the item "Mail Merge Graphics" at:

http://www.gmayor.com/mail_merge_graphics.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"blue heron" blue wrote in message
...
Is it possible to use mail merge of pictures in an excel field along with
text from other excel fields to make photo badges using Avery 5390 Name
Badge
forms? If so how do I place three lines of text to the right of the
picture?