Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alex St-Pierre
 
Posts: n/a
Default Best way to use a flexible word table with printmerge

I have a standard report which is produced using Word and Excel (printmerge).
In the standard report, I have tables which can vary (lines name, number of
items, column width)
I have try different solutions (2) and all of them have signifiant problems.
Does anyone have already done something like that ?

Approach #1:
I have add all tables in Excel and link it to Word using:
Link Excel.Sheet.8 "Variable_path" "Variable_cells".
The tables are very flexible but I have the following problems:
1- Standard Excel Underline height is defined as 1/2 point in Word and I
would like to have 1/4 point in Word (Would like to find a way to adjust Word
height in excel)
2- The link is not stable, Word 2003 SP3 jam often.
3- The file path name must be inside excel as a variable; I would like to
point directly to the same excel file as printmerge.

Approach #2:
All tables are make inside Word using variables. Since I want a line between
each table line, I can't put all conditions in a box.
The problems with this Approach a
1- The table column width can't be adjusted.
2- Since I want to have border between each elements, I have to create split
the table in n box with condition on each box.
It always insert one empty line between each elements.
ex: IF( Mergefield Item9 ) "" "
Table with border
" "") (this give a line between each table line)

would like to have:
ex: IF( Mergefield Item9 ) ""
"Table with border"
"") (Impossible to add " in the same line as the table line)

Does it exist other solutions to my problem ??
Is there a table merge function in Word ??
(Only one excel data line is used for the text merge and tables could takes
source from excel)
Thanks.
--
Alex St-Pierre
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default Best way to use a flexible word table with printmerge

Replied to duplicate question in the docmanagement
newsgroup (as well as in word.tables)

Cindy Meister

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM
is word perfect compatible with office word? Noreen Microsoft Word Help 1 May 11th 05 11:17 PM
Envelope Address GR New Users 5 April 24th 05 09:48 PM


All times are GMT +1. The time now is 09:59 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"