i have a database in excel...which i would like to take more advantage
of.

I also have some forms in Word that I was hoping to be able to get
them to be automatically completed using the excel database.

Initially thought this would be quite simple.... just record the macro
then modify it to suit.

This using simple copy from excel and paste into word document, or
pasting into form..field..values. Preferably modifying the values of
fields in the form. The form is protected, and some fields are
entered manually.

I have done a little before with excel macros - to a level of 'using
excel programming for dummies' book. But really do not know where to
start now.

Have seen this:
"Dim appWD As Word.Application
Set appWD = CreateObject("Word.Application.8")
appWD.Visible = True"

but not sure how this all fits in.

can anybody help guide me in the right direction or know of a good
simple book. not really into this heavy would just like to know how to
get this simple task done for now. not much point in learning loads of
stuff i will just forget, because i wont use it again for a while.

thanks

steve

Have you tried using Word's Mail Merge feature to pull the data from Excel?

There's information on the Word MVPs' web site:

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

Stephen Murray wrote:
i have a database in excel...which i would like to take more advantage
of.

I also have some forms in Word that I was hoping to be able to get
them to be automatically completed using the excel database.

Initially thought this would be quite simple.... just record the macro
then modify it to suit.

This using simple copy from excel and paste into word document, or
pasting into form..field..values. Preferably modifying the values of
fields in the form. The form is protected, and some fields are
entered manually.

I have done a little before with excel macros - to a level of 'using
excel programming for dummies' book. But really do not know where to
start now.

Have seen this:
"Dim appWD As Word.Application
Set appWD = CreateObject("Word.Application.8")
appWD.Visible = True"

but not sure how this all fits in.

can anybody help guide me in the right direction or know of a good
simple book. not really into this heavy would just like to know how to
get this simple task done for now. not much point in learning loads of
stuff i will just forget, because i wont use it again for a while.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi steve,

FYI, also you can you BOOKMARKS of word like this.

http://www.mrexcel.com/board2/viewto...0239&highlight

--
Message posted from http://www.ExcelForum.com