Link excel table inside a condition

[Alex St-Pierre]

Hi !
I use a mailmerge to produce 1, 2, or 3 graphics for each line of record. I
have an excel file that contains 1 graphic per sheet. The name of the sheet
is store inside {MERGEFIELD1}. After the merge, the path of each graphic must
stay variable to be able to update the document for each graphic (ctrl-A +
F9).
When I do this, all link stay in text after after the merge (work fine)
{ LINK Excel.Sheet8 "\\\\pathpath\\file.xls" "{ MERGEFIELD1 }" \a \p }
When I put the same thing inside a condition, the link MERGEFIELD1 disapear
inside the merged file.
{ IF A=B "No Graphic" "Graphic below:
{ LINK Excel.Sheet8 "\\\\pathpath\\file.xls" "{ MERGEFIELD1 }" \a \p } "}
So, I only see the table result. Since there is no link, all tables are
identical for each record (cannot update it) Is the a way to stay the link
variable when the table link is used inside a condition ?
Thanks!
Alex

 

[Peter Jamieson]

Your best bet is probably to have a blank 1-pixel graphic (let's say it is
in sheet "blank" and do something like

{ IF A = B "No Graphic" "Graphic below
" }{ LINK Excel.Sheet8 "\\\\pathpath\\file.xls" "{ MERGEFIELD sheet }" \a
\p }

if the sheet column contains "blank" when you want the blank graphic, or

{ IF A = B "{ SET mysheet "blank" }No Graphic" "{ SET mysheet "{ MERGEFIELD
sheet }" }Graphic below
" }{ LINK Excel.Sheet8 "\\\\pathpath\\file.xls" "{ MERGEFIELD sheet }" \a
\p }

if the sheet column doesn't contain anything you can rely on.

I don't know if that will work but it is what I would try.

Peter Jamieson

 

[Alex St-Pierre]

Hi Peter,
I'm wondering if there's a way to make a merge with a macro and update the
link before each record?
Thanks!
Alex

 

[Peter Jamieson]

You can use VBA and Word's MailMerge events to modify the Mail Merge Main
Document before each record is merged (MailMergeBeforeRecordMerge event).

The Word VBA has some info. on how to use events if you haven't done that
before, and you might find Doug Robbins' Addin on Graham Mayor's site at
http://www.gmayor.com/individual_merge_letters.htm useful as an example.

Peter Jamieson

Hi Peter,
I'm wondering if there's a way to make a merge with a macro and update the
link before each record?
Thanks!
Alex