J
Jason Logue
Hi, I have a user who has a cover of a document that merge
fields and
some user form data. Right now the user opens the
document up as a
template and is prompted with a userform that asks her to
enter 4
different types of information in 4 textboxes. She clicks
OK and it
inserts the data. This is the easy part. This document
can be
divided up into three different sections:
LOGO Volume # (userform entry area)
Month (entered in userform), 2003
TITLE OF DOCUMENT
Text box Table of Contents
with information Text
going down the entire Text
left side of the page One row of a table begins
here with merge
fields.
The table on the right is merged with data from another
source
(obviously), and it often overflows 2-3 pages. The
problem is that
when I use the Directory merge feature in Mail Merge
wizard, it's
night unto impossible to get this to work out well.
Ideally, the
table should list the appropriate record data, which is
project number
and project descriptions.
I first tried putting all the information, except for the
table, in
the header, but that meant the header information carried
over onto
each page, and for some reason I was unable to break the
link between
the second and third page headers.
The next thing I tried was to do the entire table in a
different
document, then open the template, and after I enter the
userform data,
insert the table. The problem with this is that usually
messes up the
formatting. By the way, I am trying to record all of
these things
with the macrorecord, so I am often limited as to what I
can do with
the table formatting-wise.
I would appreciate any help with this. It seems like it
should be a
fairly straightforward.
TIA-
Jason
fields and
some user form data. Right now the user opens the
document up as a
template and is prompted with a userform that asks her to
enter 4
different types of information in 4 textboxes. She clicks
OK and it
inserts the data. This is the easy part. This document
can be
divided up into three different sections:
LOGO Volume # (userform entry area)
Month (entered in userform), 2003
TITLE OF DOCUMENT
Text box Table of Contents
with information Text
going down the entire Text
left side of the page One row of a table begins
here with merge
fields.
The table on the right is merged with data from another
source
(obviously), and it often overflows 2-3 pages. The
problem is that
when I use the Directory merge feature in Mail Merge
wizard, it's
night unto impossible to get this to work out well.
Ideally, the
table should list the appropriate record data, which is
project number
and project descriptions.
I first tried putting all the information, except for the
table, in
the header, but that meant the header information carried
over onto
each page, and for some reason I was unable to break the
link between
the second and third page headers.
The next thing I tried was to do the entire table in a
different
document, then open the template, and after I enter the
userform data,
insert the table. The problem with this is that usually
messes up the
formatting. By the way, I am trying to record all of
these things
with the macrorecord, so I am often limited as to what I
can do with
the table formatting-wise.
I would appreciate any help with this. It seems like it
should be a
fairly straightforward.
TIA-
Jason