Reply
 
Thread Tools Display Modes
  #1   Report Post  
Marshal
 
Posts: n/a
Default merging data with forms

I am a Wordperfect user who wants to switch to Word 2003. I want to do the
following in Word: set up a document which is a list of data fields and I
want to merge that data with several forms that I will create myself. In
Wordperfect it is called a primary and secondary document. It is similiar to
a mail merge, but I want to create my own data fields and my own forms, which
I will merge together. This should be a simple thing to accomplish, but I
can't seem to figure our how to do it. Thanks.
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default merging data with forms

Yes, it's a mail merge. Just create a table in Word with your column
headings in row one, your first record in row 2, your 2nd record in row 3...
Save it in My Documents\My Data Sources folder, then create another document
and Tools--Letters and mailings...
The rest is he
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
I am a Wordperfect user who wants to switch to Word 2003. I want to do the
following in Word: set up a document which is a list of data fields and
I
want to merge that data with several forms that I will create myself. In
Wordperfect it is called a primary and secondary document. It is similiar
to
a mail merge, but I want to create my own data fields and my own forms,
which
I will merge together. This should be a simple thing to accomplish, but I
can't seem to figure our how to do it. Thanks.



  #3   Report Post  
Marshal
 
Posts: n/a
Default merging data with forms

Can I add as many fields of information as I want to the data source file? I
will need about 125 different fields of information. I am not using this
merge to send a letter to many different people. I am setting up the data
source file for one client and will merge several different forms for that
client. For another client, I will set up another different data source file
and merge that with forms that I will create.

"Anne Troy" wrote:

Yes, it's a mail merge. Just create a table in Word with your column
headings in row one, your first record in row 2, your 2nd record in row 3...
Save it in My Documents\My Data Sources folder, then create another document
and Tools--Letters and mailings...
The rest is he
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
I am a Wordperfect user who wants to switch to Word 2003. I want to do the
following in Word: set up a document which is a list of data fields and
I
want to merge that data with several forms that I will create myself. In
Wordperfect it is called a primary and secondary document. It is similiar
to
a mail merge, but I want to create my own data fields and my own forms,
which
I will merge together. This should be a simple thing to accomplish, but I
can't seem to figure our how to do it. Thanks.




  #4   Report Post  
Anne Troy
 
Posts: n/a
Default merging data with forms

Interesting, Marshal. Perhaps something like this would suit you better:
http://vbaexpress.com/kb/getarticle.php?kb_id=381
************
Anne Troy
www.OfficeArticles.com


"Marshal" wrote in message
...
Can I add as many fields of information as I want to the data source file?
I
will need about 125 different fields of information. I am not using this
merge to send a letter to many different people. I am setting up the data
source file for one client and will merge several different forms for that
client. For another client, I will set up another different data source
file
and merge that with forms that I will create.

"Anne Troy" wrote:

Yes, it's a mail merge. Just create a table in Word with your column
headings in row one, your first record in row 2, your 2nd record in row
3...
Save it in My Documents\My Data Sources folder, then create another
document
and Tools--Letters and mailings...
The rest is he
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
I am a Wordperfect user who wants to switch to Word 2003. I want to do
the
following in Word: set up a document which is a list of data fields
and
I
want to merge that data with several forms that I will create myself.
In
Wordperfect it is called a primary and secondary document. It is
similiar
to
a mail merge, but I want to create my own data fields and my own forms,
which
I will merge together. This should be a simple thing to accomplish,
but I
can't seem to figure our how to do it. Thanks.






  #5   Report Post  
Marshal
 
Posts: n/a
Default merging data with forms

Thanks Anne: If I understand this correctly, I create my data source file in
Excel, where I can have as many fields of information as I like and merge
that data into my form created in Word. I don't understand how to code my
Word document so the fields of information from Excel know where to go in the
Word document.

"Anne Troy" wrote:

Interesting, Marshal. Perhaps something like this would suit you better:
http://vbaexpress.com/kb/getarticle.php?kb_id=381
************
Anne Troy
www.OfficeArticles.com


"Marshal" wrote in message
...
Can I add as many fields of information as I want to the data source file?
I
will need about 125 different fields of information. I am not using this
merge to send a letter to many different people. I am setting up the data
source file for one client and will merge several different forms for that
client. For another client, I will set up another different data source
file
and merge that with forms that I will create.

"Anne Troy" wrote:

Yes, it's a mail merge. Just create a table in Word with your column
headings in row one, your first record in row 2, your 2nd record in row
3...
Save it in My Documents\My Data Sources folder, then create another
document
and Tools--Letters and mailings...
The rest is he
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
I am a Wordperfect user who wants to switch to Word 2003. I want to do
the
following in Word: set up a document which is a list of data fields
and
I
want to merge that data with several forms that I will create myself.
In
Wordperfect it is called a primary and secondary document. It is
similiar
to
a mail merge, but I want to create my own data fields and my own forms,
which
I will merge together. This should be a simple thing to accomplish,
but I
can't seem to figure our how to do it. Thanks.








  #6   Report Post  
Anne Troy
 
Posts: n/a
Default merging data with forms

Yep. It's really kinda designed, tho, so you'd put your data going downward
in the Excel file. For instance, your "labels" in column B (perhaps
right-aligned) and your values in column C (left aligned). EASY data entry.
What it's NOT good for is if you want to compile all your records. Then, you
really want mail merge. But if you don't mind keeping one Excel file for
each "record", then this is the answer for you. Works particularly well for
people who may make long, drawn-out quotes and maybe do a couple hundred a
year, and perhaps keep other data on the client on other worksheets of the
Excel file. I wanted it for a long time...some way to merge FROM Excel.
Then, finally one of my programmers wrote it for me. I was thrilled. Lots
of people wanting just such a solution. If you don't think this is for you,
then spill... tell us all about what you're doing, and we'll try to come up
with a good solution.
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
Thanks Anne: If I understand this correctly, I create my data source file
in
Excel, where I can have as many fields of information as I like and merge
that data into my form created in Word. I don't understand how to code my
Word document so the fields of information from Excel know where to go in
the
Word document.

"Anne Troy" wrote:

Interesting, Marshal. Perhaps something like this would suit you better:
http://vbaexpress.com/kb/getarticle.php?kb_id=381
************
Anne Troy
www.OfficeArticles.com


"Marshal" wrote in message
...
Can I add as many fields of information as I want to the data source
file?
I
will need about 125 different fields of information. I am not using
this
merge to send a letter to many different people. I am setting up the
data
source file for one client and will merge several different forms for
that
client. For another client, I will set up another different data source
file
and merge that with forms that I will create.

"Anne Troy" wrote:

Yes, it's a mail merge. Just create a table in Word with your column
headings in row one, your first record in row 2, your 2nd record in
row
3...
Save it in My Documents\My Data Sources folder, then create another
document
and Tools--Letters and mailings...
The rest is he
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Marshal" wrote in message
...
I am a Wordperfect user who wants to switch to Word 2003. I want to
do
the
following in Word: set up a document which is a list of data
fields
and
I
want to merge that data with several forms that I will create
myself.
In
Wordperfect it is called a primary and secondary document. It is
similiar
to
a mail merge, but I want to create my own data fields and my own
forms,
which
I will merge together. This should be a simple thing to accomplish,
but I
can't seem to figure our how to do it. Thanks.








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
Merging hyper link from data source Jasy Mailmerge 3 June 1st 05 12:58 PM
Merging changeable forms into Word documents Emil Onuschak Jr via OfficeKB.com Mailmerge 1 May 11th 05 03:41 PM
How do keep blank lines when merging a document with the data and. ftroop Mailmerge 1 March 30th 05 04:27 PM
Format Excel data for merging in Word BW Mailmerge 1 January 21st 05 01:25 AM
merging Word 2000 data source and word 2003 envelopes Jini Mailmerge 1 December 2nd 04 10:48 PM


All times are GMT +1. The time now is 08:24 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"