includetext field in word to import excel work sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MandyK - 24 Aug 2005 12:39 GMT

I am creating a word mail merge where when a certain criteria is met, a named
sheet from an excel wookbook is imported. I have managed to get the workbook
to import but i need to select which sheet each time. Is there any code I
can enter in the if statement so that it automatically picks up a specific
sheet when it meets the intended criteria? I'm on Microsoft Office 2003.
Below is the if statement I am currently using.

{IF { MERGEFIELD LeagueNumber } = 1 "{ INCLUDETEXT "c:\\leaguetable.xls" }"
"{ AUTOTEXT Copyright }"}

Reply to this Message

Doug Robbins - 24 Aug 2005 19:04 GMT

Use something like

{LINK Excel.Sheet.8 "C:\\Access\\tblEvaporatorLoads.xls"
"tblEvaporatorLoads!R1C1:R87C4" }

Signature

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

>I am creating a word mail merge where when a certain criteria is met, a
>named
[quoted text clipped - 8 lines]
> "c:\\leaguetable.xls" }"
> "{ AUTOTEXT Copyright }"}

Reply to this Message

MandyK - 08 Sep 2005 12:40 GMT

Thanks, this worked!

Kind regards,
MandyK

> Use something like
>
[quoted text clipped - 13 lines]
> > "c:\\leaguetable.xls" }"
> > "{ AUTOTEXT Copyright }"}

Reply to this Message