Home |
Search |
Today's Posts |
#1
|
|||
|
|||
database 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 |
#2
|
|||
|
|||
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...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 "Tasha" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Tasha" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks so much! You were a world of good information! I never knew! Again,
thanks! Tasha "Tasha" wrote: 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 |
#5
|
|||
|
|||
Thanks so much! So much good information! I appreciate it!
Tasha "Peter Jamieson" wrote: 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 "Tasha" wrote in message ... 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 |
#6
|
|||
|
|||
Thanks so much! So much good information! I appreciate it!
Tasha "Doug Robbins" wrote: 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...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 "Tasha" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does saved document open when new is selected | Microsoft Word Help | |||
saved document won't delete | Page Layout | |||
How do you set a document to only print after it is saved first? | Microsoft Word Help | |||
How do I determine a template in which a document was saved by so. | Microsoft Word Help | |||
How to stop MSWord formatting notes at the end of each saved document | New Users |