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
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
