database saved as a document, somehow, must convert to database

T

Tasha

Somehow I have saved the database I thought I was creating as a word doc.
Initially I was trying to add to my existing datasource, but I don't know
what happened from there. My main stress is that I really don't want to have
to re-type all of these hundreds of clients' names and addresses again!! Is
there anyone knows if you can transfer info to existing database/address
list? Or even just converting the existing info into a new one would be just
fine with me! I would much rather have to do a mail merge twice than re-type
all of this stuff again. PLEASE HELP!

THANK YOU!!!
Tasha
 
D

Doug Robbins

How is the data arranged in the document?

A Word document containing a table in which the cells in the first row are
the field names can be used as a datasource for a mailmerge.

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


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

Peter Jamieson

In addition to Doug's comments, if the data source where you really want to
keep this data is an Access table, and you have Access, or an Excel
spreadsheet, and you have Excel, you can copy the table and paste it into
the table in Access (open it in Spreadsheet view and select the row at the
bottom) or the Excel sheet. But
a. make sure you make a backup copy of the existing .mdb/.xls file before
attempting that
b. the columns in the Word document must be the same, and in the same
sequence, as the ones in the table/sheet
c. if the database is an "Office Address List", do not make any other
changes to the database or Word will stop recognising it as an Address List
and you will not be able to edit the data easily in Word.

Peter Jamieson
 
T

Tasha

Thanks so much! You were a world of good information! I never knew! Again,
thanks!

Tasha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't save my Office documents (after computer rebuild and reauthorization) 0
Merging from an Excel file with graphics 1
add mergefields to exsting word 2013 2
Converting excel to PDF, single page converts to multiple HELP! 1
Is it possible to create a mail merge with unformatted text links to mergefield? 1
Can I create a database from labels that are already created? 3
MS Outlook inbox to MS Accsess Database 0
Word 2007 - shared files - Excel as datasource 1

Top