have address list in Word doc, need to create a database for merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amiee K. - 16 Feb 2006 01:25 GMT

I have a list of vendors with addresses in a regular Word document. I need
to use this list as my database for a mailmerge into a letter. Is there any
way to edit and save this document as my datasource or do I have to create a
new database document? I am using Word 2003. I am familiar with Mail
Merges and can do them when the database is an Excel document. Trying to
convert the regular Word document has me stumped. Thank you.

Reply to this Message

Doug Robbins - Word MVP - 16 Feb 2006 04:56 GMT

A regular Word document can be used as a data source. The different
elements of the name and address should be in the cells of a table and the
name of each field should be in the first row of the table.

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

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

and, if necessary

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm

Signature

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

>I have a list of vendors with addresses in a regular Word document. I need
> to use this list as my database for a mailmerge into a letter. Is there
[quoted text clipped - 4 lines]
> Merges and can do them when the database is an Excel document. Trying to
> convert the regular Word document has me stumped. Thank you.

Reply to this Message