Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BobR BobR is offline
external usenet poster
 
Posts: 7
Default Data Source being lost each time the word merge document starts

Good Day,
I have numerous letters that use an Excel spreadsheet as the data source and
the documents are in WORD 2003 and the data is in EXCEL 2003.
I have code in the excel spreadsheet to simply go to
C:\MyFiles\MergeLetters\?? (?? is a specific named file) and open the WORD
document.

Once the document is opened, it just sits there and is ready for
instructions as it is a non merge format at this time. (We've tried to have
the opening code from excel to make it open to the data source and had
really poor results with it.) My question is can someone give me the proper
code (IF this can be done) that when letter one located at
C:\MyFiles\MergeLetters\letter one.doc is called upon a selfactivating macro
will fire and do the following?


When opened it will fire and make the document a mail merge with
"DataSource" as the data source. The datasource is a shortcut in the My
Docs\M\y Data Sources\"DataSource". Once this is opened the select data tab
comes up and we select the tab of data on excel. (If this could be done with
the word code that would be great). Something like datasource is My Docs\My
DataSources\DataSource and tab "datasourcetab".

Then I would have the document openedas a mail merge and either I would have
to make a selection for the datasource or it would be opened to it already??

Hope the explanation is understandable Thanks for the Assistance.
BOB



 
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
Lost data source Wraithchilde Mailmerge 2 November 17th 06 03:35 PM
Do not change data source name in the main merge document. ARY Mailmerge 3 July 24th 06 11:17 PM
How do I create a data source fo mail merge using word document Shaaban Microsoft Word Help 2 May 9th 06 05:38 PM
merge document and data source are not merging Deb in Minnesota Mailmerge 1 December 1st 05 06:31 PM
Merge multiple data in one document from same data source Jasy Mailmerge 2 October 15th 05 07:20 PM


All times are GMT +1. The time now is 12:17 PM.

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"