EXCEL/WORD - Using Merge with pictures? 1

[jonsi]

I have an Excel Worksheet containing various details about products (about 500)

I use this sheet to a WORD document using Merge. This is fine BUT...

I would now like to add one or more of a dozen or so Images to the Merge, based on information in the Worksheet
e.g. If Merge Field Img_Ref is A place Pic_1, if it's B place Pic_2 and so on.

Is this at all do-able or am I expecting too much??

thanks


hwyl
Jonsi B-)
"If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"

 

[macropod]

For each condition, insert a field coded along the lines of:
{If{MergeField Img_Ref}= "A" {INCLUDEPICTURE "C:\\FilePath\\Pic_1.jpg"}}
or:
{If«Img_Ref»= "A" {INCLUDEPICTURE "C:\\FilePath\\Pic_1.jpg"}}
where 'C:\\FilePath\\' is the path to the pictures - which needs the double backslashes for all the path separators.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field construction are all required.

Cheers
Paul Edstein
[MS MVP - Word]

 

[jonsi]

Thanks for your suggestions

hwyl
Jonsi B-)
"If an apple a day keeps the Doctor away ...why don't Daleks live in Orchards?"