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 / June 2006

Tip: Looking for answers? Try searching our database.

Need help using merge function for complex documents.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SheSmith - 13 Jun 2006 17:43 GMT
I currently use WordPerfect shells and variable documents to create complex
merge documents.  I need to transfer that task to Word.  Anyone have any
experience doing that?
Doug Robbins - Word MVP - 13 Jun 2006 19:38 GMT
Not really sure what you mean by complex merge documents.  What's complex in
WordPerfect, may be simple in Word.  Give us some more information to get
the best help.

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 currently use WordPerfect shells and variable documents to create complex
> merge documents.  I need to transfer that task to Word.  Anyone have any
> experience doing that?
Peter Jamieson - 13 Jun 2006 21:11 GMT
I last used WordPerfect data merges a long long time ago and didn't know it
well then, but if I remember correctly, WordPerfect data files can be quite
flexible and there are constructs in WordPerfect that let you loop through
records in the data source. In Word you don't get that flexibility with the
standard mailmerge - you have one, tabular data source and no looping. If
you need looping etc. you may be better off "rolling your own" merge using
Word VBA, but as Doug says, it depends on what you mean by complex.

Peter Jamieson

>I currently use WordPerfect shells and variable documents to create complex
> merge documents.  I need to transfer that task to Word.  Anyone have any
> experience doing that?
SheSmith - 14 Jun 2006 14:31 GMT
We use shell documents/data files to create wastewater permits.  The shells
are a compilation of several documents (the permit, several letters, the
supporting technical summary, etc.) and run 10 to 40 pages in length.  Things
like permit numbers, names, and addresses are repeated numerous times.  In
some instances the data field itself may be a paragraph.  There are also
comments in the shells that direct the permit writer to add/delete text.  The
documents are worked on by several different people.  The merge function
allows us to enter pertinent data only once and cuts down on errors.  Each
data file is specific to a permittee.  We do not create multiple permits from
the same data file.

WordPerfect data files are created in WordPerfect and are very flexible. WP
also has a quick entry interface for putting data into the data file
template.

Hope this is a little better explanation.  

> I last used WordPerfect data merges a long long time ago and didn't know it
> well then, but if I remember correctly, WordPerfect data files can be quite
[quoted text clipped - 9 lines]
> > merge documents.  I need to transfer that task to Word.  Anyone have any
> > experience doing that?
Doug Robbins - Word MVP - 14 Jun 2006 15:44 GMT
I am not sure that mailmerge is the best thing for this.

I would be more inclined to start with a template that contained a userform
into which the data on things like permit numbers,names, dates and addresses
are entered and then by clicking on a command button on the userform, the
various documents are created and populated with the data that is entered.

See the following series of articles, especially the last about connecting
to a database (but thinking more about what you are doing, that is where I
would be starting.)

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

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

> We use shell documents/data files to create wastewater permits.  The
> shells
[quoted text clipped - 38 lines]
>> > any
>> > experience doing that?

Rate this thread:






 
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.