Create form in Excel to use in Word for merge

[Sanukgray]

I am using MSOffice 2003. I have created a form in Excel that I want to put
into Word so I can use Mailmerge to populate the fields from the database
that I have created in Excel.
I have tried copy/paste but it did not retain the cell formatting. I was
able to use text and object, but then I could not access the cells/fields to
set up for the merge.

 

[Doug Robbins - Word MVP]

See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

and

"How to create a Mail Merge" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm


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

 

[Sanukgray]

I am using MSOffice 2003. I have created a form in Excel that I want to put
into Word so I can use Mailmerge to populate the fields from the database
that I have created in Excel.
I have tried copy/paste but it did not retain the cell formatting. I was
able to use text and object, but then I could not access the cells/fields to
set up for the merge.

I am not having difficulty setting up the mail merge itself - the difficulty
lies in the form I have created is in Excel and the merge has to take place
in Word. I can't get the master form from Excel over to Word and maintain
its integrity.

 

[Doug Robbins - Word MVP]

Getting a "master form" from Excel into Word is not part of a mail merge
operation.

What do you mean by "master form"? What is it's function?

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

 

[Sanukgray]

I have created the "Main Document" in Excel. I am trying to get the document
into Word so I can use it as the "Main Document" for the merge. When I
copy/paste the Excel document into Word, I lose some of the cell sizing. I
have tried inserting as object, and into a text box; however I can't then
access the fields.