Reply
 
Thread Tools Display Modes
  #1   Report Post  
Mail Merge Help
 
Posts: n/a
Default How to convert a mail merge document back to excel after mail mer

After I mail merge to a new document from a Excel data source. I want to
convert this document back to excel with the updated. Is there away to do
this.

Thanks
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

I don't understand your question. The merge document changes nothing about
the form doc or the record source used for the merge. It is simply a
'composite' consisting of one copy of the form document for each record in
the record source. In other words, data from the XL file is copied into the
document.

If you need to update the data stored in the XL file, that is where it
should be done. Then do the merge again. Editing the merge document will not
update the XL data file.

HTH |:)


On 8/18/05 1:35 AM, in article
, "Mail Merge Help" Mail
Merge
wrote:

After I mail merge to a new document from a Excel data source. I want to
convert this document back to excel with the updated. Is there away to do
this.

Thanks


  #3   Report Post  
Mail Merge Help
 
Posts: n/a
Default

Cyber

Say instead of send out the excel spreadsheet to another user, I mail merge
all the data to a word document in a form format, this could be 50 pages. If
the user change/edit on the word document, instead of copy and paste it back
to the original source with the changes, I want to convert this 50 pages back
to excel.

Is there a way to do this.

Thanks

"CyberTaz" wrote:

I don't understand your question. The merge document changes nothing about
the form doc or the record source used for the merge. It is simply a
'composite' consisting of one copy of the form document for each record in
the record source. In other words, data from the XL file is copied into the
document.

If you need to update the data stored in the XL file, that is where it
should be done. Then do the merge again. Editing the merge document will not
update the XL data file.

HTH |:)


On 8/18/05 1:35 AM, in article
, "Mail Merge Help" Mail
Merge
wrote:

After I mail merge to a new document from a Excel data source. I want to
convert this document back to excel with the updated. Is there away to do
this.

Thanks



  #4   Report Post  
CyberTaz
 
Posts: n/a
Default

Perhaps I'm dense, but I'm still totally unclear on what you are trying to do.

The '50 page doc' doesn't correspond to what a mail merge is used for. It
sounds more like you are trying to _Insert_ an Excel file into a Word doc.

If you need to have someone update the data in a worksheet why not just send
them that instead of trying to put it into Word & back to Excel again?

Even if what you're asking is possible there is always more risk of error
when transferring data back & forth between different file types.

Regards |:)

"Mail Merge Help" wrote:

Cyber

Say instead of send out the excel spreadsheet to another user, I mail merge
all the data to a word document in a form format, this could be 50 pages. If
the user change/edit on the word document, instead of copy and paste it back
to the original source with the changes, I want to convert this 50 pages back
to excel.

Is there a way to do this.

Thanks

"CyberTaz" wrote:

I don't understand your question. The merge document changes nothing about
the form doc or the record source used for the merge. It is simply a
'composite' consisting of one copy of the form document for each record in
the record source. In other words, data from the XL file is copied into the
document.

If you need to update the data stored in the XL file, that is where it
should be done. Then do the merge again. Editing the merge document will not
update the XL data file.

HTH |:)


On 8/18/05 1:35 AM, in article
, "Mail Merge Help" Mail
Merge
wrote:

After I mail merge to a new document from a Excel data source. I want to
convert this document back to excel with the updated. Is there away to do
this.

Thanks



  #5   Report Post  
Mail Merge Help
 
Posts: n/a
Default

Thanks Taz

"CyberTaz" wrote:

Perhaps I'm dense, but I'm still totally unclear on what you are trying to do.

The '50 page doc' doesn't correspond to what a mail merge is used for. It
sounds more like you are trying to _Insert_ an Excel file into a Word doc.

If you need to have someone update the data in a worksheet why not just send
them that instead of trying to put it into Word & back to Excel again?

Even if what you're asking is possible there is always more risk of error
when transferring data back & forth between different file types.

Regards |:)

"Mail Merge Help" wrote:

Cyber

Say instead of send out the excel spreadsheet to another user, I mail merge
all the data to a word document in a form format, this could be 50 pages. If
the user change/edit on the word document, instead of copy and paste it back
to the original source with the changes, I want to convert this 50 pages back
to excel.

Is there a way to do this.

Thanks

"CyberTaz" wrote:

I don't understand your question. The merge document changes nothing about
the form doc or the record source used for the merge. It is simply a
'composite' consisting of one copy of the form document for each record in
the record source. In other words, data from the XL file is copied into the
document.

If you need to update the data stored in the XL file, that is where it
should be done. Then do the merge again. Editing the merge document will not
update the XL data file.

HTH |:)


On 8/18/05 1:35 AM, in article
, "Mail Merge Help" Mail
Merge
wrote:

After I mail merge to a new document from a Excel data source. I want to
convert this document back to excel with the updated. Is there away to do
this.

Thanks


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
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. Chris Green Mailmerge 5 October 8th 05 03:51 PM
Print envelops from a mail merge document Jim Mailmerge 7 June 21st 05 05:33 AM
How do I mail merge data from different Excel worksheets into one. blw Microsoft Word Help 1 March 23rd 05 06:39 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 03:45 PM
Excel dates formatted d/m/yy convert to m/d/yy in mail merge GayleT Mailmerge 1 November 29th 04 02:43 AM


All times are GMT +1. The time now is 09:28 PM.

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

About Us

"It's about Microsoft Word"