Can I make a database in Word with Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Myn777 - 12 Dec 2005 20:16 GMT

I know this may be a "DUH" question, but...

I am making a list of area dentists that I have copied and pasted of
of the Dex website into Excel. I am wondering if I can take this inf
and make a database in Word for printing address labels. Does anyon
know if this can be done, and HOW?:confused

Reply to this Message

Gord Dibben - 12 Dec 2005 20:30 GMT

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

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

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

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033

Gord Dibben Excel MVP

>I know this may be a "DUH" question, but...
>
>I am making a list of area dentists that I have copied and pasted off
>of the Dex website into Excel. I am wondering if I can take this info
>and make a database in Word for printing address labels. Does anyone
>know if this can be done, and HOW?:confused:

Reply to this Message

Peo Sjoblom - 12 Dec 2005 20:30 GMT

You use excel as database source and word for mailmerging

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Signature

Regards,

Peo Sjoblom

> I know this may be a "DUH" question, but...
>
> I am making a list of area dentists that I have copied and pasted off
> of the Dex website into Excel. I am wondering if I can take this info
> and make a database in Word for printing address labels. Does anyone
> know if this can be done, and HOW?:confused:

Reply to this Message

swatsp0p - 12 Dec 2005 20:34 GMT

I would think you could use your Excel file for a Mail Merge. Word ha
a wizard that can walk you through step by step...

Good Luck

Bruc

--
swatsp0

Reply to this Message

Myn777 - 12 Dec 2005 20:41 GMT

Thanks for the input. I think that I will have to work on the format of
the excel doc before it will work. I think it needs the headings before
it will register as a database? Any input?

:cool:

Signature

Myn777

Reply to this Message

Gord Dibben - 12 Dec 2005 21:27 GMT

Can't see your data so hard to tell.

You need headings for each column.

Name, Address, City, State, Zip............as a minimum

Each record must be on a row under the headings.

Any of the sites I listed in my posting will show you the format.

Take a quick tour of the training tutorial to get a feel for it.

Gord

>Thanks for the input. I think that I will have to work on the format of
>the excel doc before it will work. I think it needs the headings before
>it will register as a database? Any input?
>:cool:

Reply to this Message