Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2003

Tip: Looking for answers? Try searching our database.

Mail merge into tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason Logue - 19 Oct 2003 22:23 GMT
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
Doug Robbins - Word MVP - 20 Oct 2003 09:51 GMT
Hi Jason,

The Directory type mailmerge can really only be used in a document with the
mergefields in it and nothing else.

Sounds to me like you should probably be using a report in Access

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
> Hi, I have a user who has a cover of a document that merge
> fields and
[quoted text clipped - 57 lines]
> TIA-
> Jason
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.