Excel data base

[Guest]

It's my habit to keep my data bases in Excel and use those spreadsheets for
printing labels when I do a marketing mailing.

I recently scanned and OCR'd a local business directory into Word. Is there
any way that those address blocks can be more easily inserted into my Excel
Workbook without using copy & paste to insert the text into each Column/Row
line by line?

Thanks!

 

[Anne Troy]

Denise: Yes, there sure is, but we'd have to see the layout and then the
instructions could actually be very lengthy to write. I'm extremely good at
this kind of thing and am willing to do it for you if you'd like to send the
file to ng@ the web in my signature. Alternatively, perhaps Graham's
instructions will work for you:
http://www.gmayor.com/convert_labels_into_mail_merge.htm
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Thanks so much! I linked up with the instructions you referenced and see the
process from labels to table and reverse. I'm going to try to go through it
step by step. When the table is completed in Word can it be converted to
Excel? I prefer working there.

 

[Anne Troy]

You bet. Just select and copy the table. Paste into Excel. At that point, I
usually keep it all protected and Format-->Cells, Alignment tab and uncheck
text wrapping.
************
Anne Troy
www.OfficeArticles.com