Mailmerge - boolean field + picture

[Jake]

Hi,

I have an access table which contains among other fields a boolean field
named 'PrintMe' and a text field with a full path to a thumbnail image.

I want to run a mailmerge on labels from this table. I have created the
main document (which of course is no problem).

BUT

1. I want all the records with PrintMe=FALSE skipped (they should not be
printed).

2. I want the thumbnail *image* printed on the label (and not the
thumbnail path .

How do I achieve this...?

regards

jake

 

[Graham Mayor]

The boolean field should produce a result of 1 or 0. Add a SKIPIF field to
the first cell of the label merge document {SKIPIF {Mergefield PrintMe} =
0} and propagate the labels again.
With reference to the graphic use an IncludePicture field to call the image
path from the data source - see
http://www.gmayor.com/mail_merge_graphics.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jake]

Graham Mayor skrev:

The boolean field should produce a result of 1 or 0. Add a SKIPIF field to
the first cell of the label merge document {SKIPIF {Mergefield PrintMe} =
0} and propagate the labels again.
With reference to the graphic use an IncludePicture field to call the image
path from the data source - see
http://www.gmayor.com/mail_merge_graphics.htm

Thanks a lot ;-)

jake

 

[Jake]

Jake skrev:

Graham Mayor skrev:

Thanks a lot ;-)

jake

Hi again

After having tried the success is partial :-|

I can manage to get an empty picture frame up in the label, but no
actual picture. The full size of the image is a lot less than the
label's size.

I have tried with single and double backslashes, I have hrardcoded the
full path of a fixed file (no mergefield in the fileename), but all I
get ut is an empty picture frame.

Originally there weren't even picture frames, but they popped ut after I
had run the updateall macro suggested in the gmayor pages.

My files are in BMP format but I have tried with test files in JPG bu to
no avail.

Thanks a lot for tips on further suggestions.

jake

 

[Graham Mayor]

OK. I take it you have merged to a new document?

If you insert the picture path field into a document on its own and merge
that with your data source what is the exact result of the field?
Are all the images in the same folder?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins - Word MVP]

Try Ctrl+a then F9 to update the fields

--
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