Reply
 
Thread Tools Display Modes
  #1   Report Post  
maggiev
 
Posts: n/a
Default How do I create & merge specific data base & master documents?

We are converting our master documents from WordPerfect to Word for our
estate planning clients. I need to delete WP fields and insert Word fields
and then create a data base for individual clients. Can Word do that or
are data bases only for address info, etc.?
  #2   Report Post  
Jerry
 
Posts: n/a
Default

What version of Word are you using and what do you want to put in the fields
besides "address info"?

"maggiev" wrote:

We are converting our master documents from WordPerfect to Word for our
estate planning clients. I need to delete WP fields and insert Word fields
and then create a data base for individual clients. Can Word do that or
are data bases only for address info, etc.?

  #3   Report Post  
Charles Kenyon
 
Posts: n/a
Default

I use mailmerge with an Excel spreadsheet as a datafile for my legal
pleadings. Works very nicely. I added a button to my mailmerge toolbar to
lock all the fields once I've done the merge to the screen. Note, I merge to
the screen in a new document based on the template, rather than merging to a
new document or to the printer. I use the Excel spreadsheet because a Word
table is limited to 22 columns (AFAIK) and that limits a datafile to 22
fields (which are unreadable).

Note, what you are calling a "master document" is called a template in Word,
I think. Word has a "Master Document" feature which you should avoid.

See below on converting documents from WP to Word.



Here is some general info on moving from Word Perfect to Word:

Word and Word Perfect work very differently from one another. Each program's
methods have strengths and weaknesses; but, if you try to use one of these
programs as if it were the other, it is like pushing on a string! You can
easily make a lot of extra work for yourself. If you are unwilling to take
the time to learn to use Word's methods, you should stick to using Word Pad.
You'll have a lot less grief, although you'll miss out on a lot of raw
power.

See http://www.addbalance.com/word/wordperfect.htm
http://www.mvps.org/word/FAQs/Genera...ordPerfect.htm
http://www.mvps.org/word/FAQs/Genera...AndGotchas.htm
http://www.mvps.org/word/FAQs/General/RevealCodes.htm
http://www.mvps.org/word/FAQs/Genera...Converters.htm
http://businesssoft.about.com/comput.../blconvert.htm
for information on Word for Word Perfect users.

For mo
http://www.mvps.org/word/FAQs/Custom...platePart2.htm
http://www.mvps.org/word/FAQs/Custom...platePart1.htm
http://www.addbalance.com/usersguide/templates.htm
http://www.mvps.org/word/FAQs/Number...gExplained.htm
http://www.addbalance.com/usersguide/styles.htm
http://www.mvps.org/word/FAQs/Custom...latesStore.htm


Function Keys

In Word 2000 (or later) You can get the function keys to display in a
special toolbar at the bottom of the screen if you want (something like
pressing F3 twice in WP). The following macro will do this.
Sub ShowMeFunctionKeys()
Commandbars("Function Key Display").Visible = True
End Sub

Word's Extend key (F8) gives something similar to block processing.


Formatting and Styles

Learn about Styles - really learn!
http://www.addbalance.com/usersguide/styles.htm I resisted for years and now
regret every day of those years because although that string was still very
hard to push, it kept getting longer and longer, and had some very important
projects tied to it! Once you understand styles and the Word concept of
organizing things into Chinese boxes everything falls into place and instead
of pushing a string, you can push a button that turns on the very powerful
text processing machine known as Microsoft Word and it will start doing your
work for you instead of running around behind you trying to undo what you
just thought you did.


Converting documents Word / Word Perfect

Some special characters in Word Perfect documents don't convert well to
Word. There is a macro to assist with this described at
http://www.columbia.edu/~em36/wpdos/...html#macroword and can be found
at http://www.columbia.edu/~em36/wpdos/WPSymbolConv.bas.
This was prepared by Edward Mendelson.
Otherwise, look at the macro from http://support.microsoft.com/?kbid=212396
Use these on _copies_!

As for converting documents from Word Perfect to _use_ in Word... In a word,
don't plan on it. I would not recommend using converted documents long-term.
They will be filled with formatting anomolies that will get you at the worst
time. This is especially true of any documents containing automatic
numbering or bullets. Try recreating form documents in Word using the
following process:
In Word Perfect (if you still have it, in Word if not) save your files as
text files.
Use your converted files as references to show you how you want your
formatting to look.
Create a new document in Word and insert the text from the text file. Save
this new document as a Word template. Format it the way you want using
styles, not direct formatting. Save it again.
To use a template within Word, use File = New and pick your template. This
will create a new document for you.

Merge documents have special problems and should be recreated from text
files or retyped in Word. To convert data files, consider generating labels
in WP as a document, converting that to Word, and then using
http://www.gmayor.com/convert_labels...mail_merge.htm to get a new Word
data file.

Note that conversions usually do create documents that look passable and
print OK; the problems I'm referring to have to do with editing / making
changes, that is, using the documents long-term. (See below on reusing
documents vs. using templates.)

Conversion back to Word Perfect: There is a problem (in addition to the ones
mentioned for conversion _to_ Word) with Version 2002 (XP) and later of
Word. The conversion file only works for conversion _to_ Word, not from Word
to Word Perfect! Earlier versions went both ways. To fix this, you need to
find the old conversion file WPFT532.CNV from a Word 97 or Word 2000
installation and copy it to your new installation, replacing the file of the
same name. Note, the change making the file one-way was done as a security
measure. While I don't know of any problems the old file causes, keep the
new installation's file somewhere as a backup just in case.


Boilerplate and Forms

In WP a lot of people use macros to hold chunks of text - boilerplate. In
Word this function is filled by Templates, AutoText and AutoCorrect, not
macros. Follow the links at
http://addbalance.com/word/wordwebre...s.htm#AutoText for more
information on these tools.

You can use FILLIN and ASK fields or UserForms to query the user. For some
form documents, Word's "online forms" work very well. For more about online
forms, follow the links at
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm especially Dian
Chapman's series of articles.


Reusing Documents vs. Using templates

General practice in WP is to have a document and copy and edit it to create
a new document. This is not good practice in Word. In Word, construct a
good, tight, template for your documents and use that template when
constructing new documents. Among other things, this can avoid embarrassing
"metadata" (http://www.addbalance.com/usersguide/metadata.htm) and things
like surprise headers and footers from creeping into new documents.

It's a lot of reading, I know. It's OK to chunk it down and do a bit each
day, but I would recommend that you make it a top priority to do that bit
each day. In the (short) long run, it will save you both time and grief.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"maggiev" wrote in message
...
We are converting our master documents from WordPerfect to Word for our
estate planning clients. I need to delete WP fields and insert Word
fields
and then create a data base for individual clients. Can Word do that or
are data bases only for address info, etc.?



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
Can you create a multi-layered merge where certain merge fields a. mileszat Mailmerge 3 January 18th 05 04:46 AM
stripping commas from merge data Patrick Heilman Mailmerge 0 December 30th 04 05:09 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM
how do i create a mail merge for email using excel as a data sourc AnnA Mailmerge 1 December 1st 04 01:57 AM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 08:15 PM


All times are GMT +1. The time now is 08:01 AM.

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"