Can I make a database in Word with Excel Data

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?

You use excel as database source and word for mailmerging

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

--

Regards,

Peo Sjoblom



"Myn777" <Myn777.1zy1ja_1134418801.0021@excelforum-nospam.com> wrote in
message news:Myn777.1zy1ja_1134418801.0021@excelforum-nospam.com...
>
> 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?
>
>
> --
> Myn777
> ------------------------------------------------------------------------
> Myn777's Profile:
http://www.excelforum.com/member.php...o&userid=29584
> View this thread: http://www.excelforum.com/showthread...hreadid=492836
>

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 14:16:30 -0600, Myn777
<Myn777.1zy1ja_1134418801.0021@excelforum-nospam.com> wrote:

>
>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?

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?

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

On Mon, 12 Dec 2005 14:41:02 -0600, Myn777
<Myn777.1zy2oz_1134420306.7549@excelforum-nospam.com> wrote:

>
>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?
>