I am familiar with using an Access database and populating fields in Word,
can you do the same thing in Excel.
--
S

Sharon

Not really sure what you mean but is DataForm... what you are looking for?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Sharon" wrote in message
...
I am familiar with using an Access database and populating fields in Word,
can you do the same thing in Excel.
--
S

no, although that is pretty cool. I already have the field values in an
Access database. I can only tell you how I accomplish this in Word because I
don't know Excel enough to explain. But, basically, when you have a Word
document open, you can open a datasource (Access database) and on the Mail
Merge Toolbar you can insert a particular field (just like one of the
"fields" on the data form"). For instance, name, address, telephone number.
You then open the mail merge receipient list and select the records you want
to include. You then select "merge to new document" and it will "populate"
the fields with the records that you selected. Sorry, I am not very good at
explaining, but I guess that it is like Data/Form, but I have the information
in an Access database? Any help is appreciated. Thanks.--
S


"Sharon" wrote:

I am familiar with using an Access database and populating fields in Word,
can you do the same thing in Excel.
--
S