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

--
Myn77
-----------------------------------------------------------------------
Myn777's Profile: http://www.excelforum.com/member.php...fo&userid=2958
View this thread: http://www.excelforum.com/showthread.php?threadid=49283

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
<(E-Mail Removed)> 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?

You use excel as database source and word for mailmerging

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

--

Regards,

Peo Sjoblom



"Myn777" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=49283

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?



--
Myn777
------------------------------------------------------------------------
Myn777's Profile: http://www.excelforum.com/member.php...o&userid=29584
View this thread: http://www.excelforum.com/showthread...hreadid=492836

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
<(E-Mail Removed)> 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?
>