Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
frankfox44
 
Posts: n/a
Default Merging data from Excel to Word

Impossiblit situation now with Office XP. Merging date, for example, grades,
to Word, for example, a transcripit, grade/status sheets. Used to be so
simple. Now multiple digits instead of 6.00 as recorded in the Excel file.
While in Word document, the Excel file is no longer present on the taskbar
for easy checking. Resolutions?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

frankfox44 wrote:
Impossiblit situation now with Office XP. Merging date, for example, grades,
to Word, for example, a transcripit, grade/status sheets. Used to be so
simple. Now multiple digits instead of 6.00 as recorded in the Excel file.
While in Word document, the Excel file is no longer present on the taskbar
for easy checking. Resolutions?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3   Report Post  
frankfox44
 
Posts: n/a
Default

Good, helped me tremendously. However, one nagging item. In several older
Word and Excel files that have been linked through a successful merger
procedure, the Excel document is displayed and available on the Taskbar. With
the new version, it is not (irritating). Then when clicking the button to
open the data source, one must go through the process of locating the data
source. Once located, it can be opened, but with the dialogue box stating
"Read Only" or "Notify".
Restoring the data source file (the Excel data file) to the Taskbar would
indeed be most helpful.
frankfox44

"Debra Dalgleish" wrote:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

frankfox44 wrote:
Impossiblit situation now with Office XP. Merging date, for example, grades,
to Word, for example, a transcripit, grade/status sheets. Used to be so
simple. Now multiple digits instead of 6.00 as recorded in the Excel file.
While in Word document, the Excel file is no longer present on the taskbar
for easy checking. Resolutions?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If you use the DDE connection, the linked Excel document should open.
For other types of connection, I think you have to hunt for the file.

You could ask in the Word MailMerge newsgroup, and someone may be able
to help.

frankfox44 wrote:
Good, helped me tremendously. However, one nagging item. In several older
Word and Excel files that have been linked through a successful merger
procedure, the Excel document is displayed and available on the Taskbar. With
the new version, it is not (irritating). Then when clicking the button to
open the data source, one must go through the process of locating the data
source. Once located, it can be opened, but with the dialogue box stating
"Read Only" or "Notify".
Restoring the data source file (the Excel data file) to the Taskbar would
indeed be most helpful.
frankfox44

"Debra Dalgleish" wrote:


There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

frankfox44 wrote:

Impossiblit situation now with Office XP. Merging date, for example, grades,
to Word, for example, a transcripit, grade/status sheets. Used to be so
simple. Now multiple digits instead of 6.00 as recorded in the Excel file.
While in Word document, the Excel file is no longer present on the taskbar
for easy checking. Resolutions?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Automation from Excel to Word Adam Excel Discussion (Misc queries) 3 February 22nd 05 02:43 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 02:45 AM
combined cell data from Excel to Word (2003) Adam Excel Discussion (Misc queries) 2 February 14th 05 03:29 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"