Anne Troy
04-11-2005, 06:12 PM
I only need to know if we CAN do it...
Suppose I want to finish typing my data into an Excel file.
I hit Save.
Then I hit a button....
Now, manually, I'd close Excel, open the Word document and run the auto-mail merge code that's in there (or let it run on Document-Open).
But what I want to know is can we do something so that the mail merge is launched without closing Excel? See...the mail merge needs to merge to this Excel document.
Alternatively, how much more difficult would it be for me to store data into a 2nd Excel file, and use "this" one for Input and Merge.
Suppose I want to finish typing my data into an Excel file.
I hit Save.
Then I hit a button....
Now, manually, I'd close Excel, open the Word document and run the auto-mail merge code that's in there (or let it run on Document-Open).
But what I want to know is can we do something so that the mail merge is launched without closing Excel? See...the mail merge needs to merge to this Excel document.
Alternatively, how much more difficult would it be for me to store data into a 2nd Excel file, and use "this" one for Input and Merge.