 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2005database saved as a document, somehow, must convert to database
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 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  SignatureHope 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 > 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 [quoted text clipped - 11 lines] > THANK YOU!!! > Tasha Thanks so much! So much good information! I appreciate it! Tasha > How is the data arranged in the document? > [quoted text clipped - 21 lines] > > THANK YOU!!! > > Tasha 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 > 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 [quoted text clipped - 11 lines] > THANK YOU!!! > Tasha Thanks so much! So much good information! I appreciate it! Tasha > 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 [quoted text clipped - 25 lines] > > THANK YOU!!! > > Tasha Thanks so much! You were a world of good information! I never knew! Again, thanks! 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 [quoted text clipped - 7 lines] > THANK YOU!!! > Tasha |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.