Hi all,
I have a problem, at work we use a database program (Dutch) in which al the data of our projects (custumor details etc) are stored.
From this database program it is possible to execute a mailmerge to Word, this works perfectly.... but now my problem. I need the data in Excel, not in Word.
Now tried several things;
- I called the company to make it possible to link to Excel, denied.
- I added VBA code in Word which acts on opening the document, problem is, VBA code is executed before the merge. So this doesnt work.
- I added a button to my document which should trigger a VBA code to link everything to Excel. The problem is, my code is gone after the merge?!
Does anyone has an idea how to get data from the database into Excel?
If there is a way to keep the code after the merge, this will be fine, pressing a button once is do-able.
Please help!
Mathijs.
I have a problem, at work we use a database program (Dutch) in which al the data of our projects (custumor details etc) are stored.
From this database program it is possible to execute a mailmerge to Word, this works perfectly.... but now my problem. I need the data in Excel, not in Word.
Now tried several things;
- I called the company to make it possible to link to Excel, denied.
- I added VBA code in Word which acts on opening the document, problem is, VBA code is executed before the merge. So this doesnt work.
- I added a button to my document which should trigger a VBA code to link everything to Excel. The problem is, my code is gone after the merge?!
Does anyone has an idea how to get data from the database into Excel?
If there is a way to keep the code after the merge, this will be fine, pressing a button once is do-able.
Please help!
Mathijs.
