Hi to all learned VBA-people,


I am quite new to this, and as such, inevitably got stuck with something trivial.

I have a database in Excel (2007) and made a commandbutton that calls a macro.

The macro starts an instance of Word (2007) and opens a letter that already has all the merge fields inserted.

The two trivial questions are:

1. How do I program excel, to let Word pose the question it always poses when i open that Rod doc manually (you know, the one about whether it is OK to use the worksheet xxx as database) an make the VBA code say yes, OR how to avoid the question, as the answer shall ultimately be YES.

2. Since I am lazy as can be, I'd like to avoid having to run the Word macro (stored in that letter the VBA code opens for mail merge) "manually".
I am positive there is a way to run that macro, but for the life of me, cannot figure out how to write with proper sytax.

Any help is greatly appreciated.

best,

Subby