Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Link excel table inside a condition
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 -- Alex St-Pierre |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Link excel table inside a condition
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" wrote in message ... 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 -- Alex St-Pierre |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Link excel table inside a condition
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 -- Alex St-Pierre "Peter Jamieson" wrote: 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" wrote in message ... 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 -- Alex St-Pierre |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Link excel table inside a condition
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 "Alex St-Pierre" wrote in message ... 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 -- Alex St-Pierre "Peter Jamieson" wrote: 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" wrote in message ... 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 -- Alex St-Pierre |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHH! Justified words inside a box...incluing picture link to help explain,,, | Page Layout | |||
Embedding SEQ inside of a LINK field | Microsoft Word Help | |||
How to link to paragraph 3 of page 12, inside a Word document. | Microsoft Word Help | |||
will "field link" link a table in Word to an Excel table? | Tables | |||
Table link to Excel | Tables |