Reply
 
Thread Tools Display Modes
  #1   Report Post  
Tasha
 
Posts: n/a
Default 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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   Report Post  
Tasha
 
Posts: n/a
Default

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   Report Post  
Tasha
 
Posts: n/a
Default

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   Report Post  
Tasha
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
why does saved document open when new is selected specialk Microsoft Word Help 1 May 19th 05 06:55 PM
saved document won't delete happy2day Page Layout 4 May 11th 05 06:17 AM
How do you set a document to only print after it is saved first? Jacob Microsoft Word Help 2 April 12th 05 04:33 AM
How do I determine a template in which a document was saved by so. Mike Corcoran Microsoft Word Help 2 April 5th 05 05:15 PM
How to stop MSWord formatting notes at the end of each saved document Larry Brickner New Users 4 April 5th 05 05:04 PM


All times are GMT +1. The time now is 08:29 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"