View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sharon
 
Posts: n/a
Default Field Population

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