collect data from DBF / XLS file for Mail Merge

[BS10]

Hi,

my company uses a database to store client information such as client
names, addresses, phone no's etc. Each client has a unique client code.
I would like to pull data from the database into Word. For example when
typing a letter to a client, I would like to simply type in the client
code and have Word pull the Client Name & Address from either a dbf /
xls file.
Is this possible?

Thanks,

B

 

[Bob Buckland ?:-\)]

Hi Brian,

Generally, it would be easier to run a query in
either Access or Excel to select the records you
want Word to merge, but you may want to check with
the folks in the Word Mailmerge newsgroup (link below)
and include the version of Word/Excel et al you are using.

=========
Hi,

my company uses a database to store client information such as client
names, addresses, phone no's etc. Each client has a unique client code.
I would like to pull data from the database into Word. For example when
typing a letter to a client, I would like to simply type in the client
code and have Word pull the Client Name & Address from either a dbf /
xls file.
Is this possible?

Thanks,

B >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com