Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] jonmallin@gmail.com is offline
external usenet poster
 
Posts: 4
Default MS Word Mail Merge from Excel -- Force Excel to open the datafile?

I am working on a mail merge from an MS Excel (Office 2002 SP3)
spreadsheet into Word (Office 2002 SP3). The merge itself is working
well. Generally, when I open up a Word file that contains a mail
merge, the Excel file with the merge data opens automatically.
However, sometimes the Excel file doesn't open automatically. Is
there some setting or work around to force the Excel file to open
always?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] jonmallin@gmail.com is offline
external usenet poster
 
Posts: 4
Default MS Word Mail Merge from Excel -- Force Excel to open thedatafile?

More info.. switched from Office 2000 to Office XP. It seems that
documents created in Office 2000 automatically open the Excel data
source. In Office XP, it seems that the data source does not load
automatically.

Anyone else encounter this? Any solutions?
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default MS Word Mail Merge from Excel -- Force Excel to open the datafile?

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, select the DDE
option in the dialog that appears asking be what method the connection
should be made.

--
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

wrote in message
...
More info.. switched from Office 2000 to Office XP. It seems that
documents created in Office 2000 automatically open the Excel data
source. In Office XP, it seems that the data source does not load
automatically.

Anyone else encounter this? Any solutions?



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] jonmallin@gmail.com is offline
external usenet poster
 
Posts: 4
Default MS Word Mail Merge from Excel -- Force Excel to open thedatafile?

I did some testing and it seems that if I create a mail merge document
in Word 2000, then the Excel data file automatically opens when I open
the Word file. If I create a mail merge document in Word 2002 (XP/
SP3), then the Excel data file does not automatically open. Is there
a way to force the Excel file to open in Word 2002 (XP/SP3)? Thanks
in advance.

  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default MS Word Mail Merge from Excel -- Force Excel to open the datafile?

See response above.

--
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

wrote in message
...
I did some testing and it seems that if I create a mail merge document
in Word 2000, then the Excel data file automatically opens when I open
the Word file. If I create a mail merge document in Word 2002 (XP/
SP3), then the Excel data file does not automatically open. Is there
a way to force the Excel file to open in Word 2002 (XP/SP3)? Thanks
in advance.





  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default MS Word Mail Merge from Excel -- Force Excel to open the datafile?

Does it connect if the Excel file is in the same folder as the merge
document or in the My Data Sources folder?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
More info.. switched from Office 2000 to Office XP. It seems that
documents created in Office 2000 automatically open the Excel data
source. In Office XP, it seems that the data source does not load
automatically.

Anyone else encounter this? Any solutions?



  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] jonmallin@gmail.com is offline
external usenet poster
 
Posts: 4
Default MS Word Mail Merge from Excel -- Force Excel to open thedatafile?

On Sep 25, 8:27*pm, "Doug Robbins - Word MVP"
wrote:
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. *Then when
you attach the data source to the mail merge main document, select the DDE
option in the dialog that appears asking be what method the connection
should be made.


Doug,

Thanks. I'm still having some difficulty. When I open the Word
document, I get a box that says Word cannot find its data source.
Both the Word and Excel file are in the same directory. Ugh!
Thanks again.

Jon
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
Excel-MS Word Mail Merge open error Chila 10-22-07[_2_] Mailmerge 2 October 22nd 07 03:59 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
Unable to open excel data source for word mail merge Trisha Microsoft Word Help 0 October 18th 05 10:59 AM
mail merged in word w/ address list in excel, now cant open excel MAIL MERGE from Excel Mailmerge 3 May 9th 05 05:31 PM


All times are GMT +1. The time now is 07:09 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"