Calling Alber Kallal on Easy Word Merge!!!!

[Stockwell43]

Hi Albert,

I have a question about your Mail Merge which I absolutely love it and think
you did a fabulous job in creating it!!!!!

Also, when I create the word document and place in the fields everything
works fine. The only question I have is:

When I click ok - merge to word, I get this message that pops up:

Opening this document will run the following SQL Command:
SELECT*From C:\Docume~1\etc.... etc....\merge 88
Data from your database will be placed in the document
Do you want to contimue? Yes No.

Question 1: Is this suppose to pop up or did I do something wrong? It seems
to show the correct data on the word document.

Question 2: If this message is correct, can the wording be changed to
something like "You are about to merge data, do you want to continue?"

 

[Peter Hibbs]

Perhaps this site will help :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;825765

Peter Hibbs.

 

[Stockwell43]

Hi Peter,

No, I was more wondering why I get the message popping up. Of course, I
don't have it working off of a query but I am not expecting the users to
print multiple docs. However, in order to get rid of the message if I have to
do the query I suppose I can go that route.

 

[Peter Hibbs]

I'm not familiar with Albert's code but when I had the same problem
with my own code I made the Registry change that is recommended in
that article and that got rid of the message. The reason it appears, I
believe, is because Microsoft added this security feature in A2002/3.

Perhaps Albert will have other thoughts.

Peter Hibbs.

 

[Albert D. Kallal]

Opening this document will run the following SQL Command:
SELECT*From C:\Docume~1\etc.... etc....\merge 88
Data from your database will be placed in the document
Do you want to contimue? Yes No.

Hum, what version of access + word are you using?

As a side note, you SHOULD NOT be getting that message.

Question 1: Is this suppose to pop up or did I do something wrong? It
seems
to show the correct data on the word document.

No, it is not supposed to appear. My code gets around that problem, and I
tested even with office 2007.

The only thing I can guess at is you downloaded the access 97 version (which
has not been updated for a long time now).

So, I would make sure you downloaded the a2000 version here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


Also, do you get this error message when you use my sample download?

Try editing the document (again using the "edit" option from the merge form
to open the word document -- do NOT open the document by clicking on the
actual merge document). Add a space, delete a space, and then save the word
document.

Now, try the merge again.

I am not receiving that error message about the sql when I do the merge. It
is possible that your word document(s) were moved to a 'read only'
directory..but, I at a loss as to what is going on here...

So, try re-downloading my sample...create merge doc (you have to insert at
least one field for it to work), save word doc, and try the merge.

check the above points..and mention what version of office (accedes) and
word you are using, and see if the download sample avoids the nag message.

 

[Stockwell43]

Hi Guys, thank you both for replying.

I am using Access and Word 2003. Is it possible because I am not using a
query to merge I am getting the message? When I tried it, I was on the
current record, click the button to pop up the merge form, select the
document and click merge and the message pops up but if I click Yes, it does
what it is suppose to do anyway so I just thought it was like that because I
wasn't running the query.

Outside of that, it is seems to work fine and is quite easy to use and
install. If you guys can give me some specifics as to what I need to do to
fix it that would be great. If not, it does work as is and I would just tell
the users to always click Yes when the message pops up.

Thanks!!!!

 

[Stockwell43]

Hi Guys,

FYI - for some reason I went in the database this morning to play around and
before doing anything I tried the merge again and this time I didn't get the
message. I did it several times on different records and worked fine. Did I
need to close the database after installing to reset it or restart the
computer? Very strange.

 

[Albert D. Kallal]

Is it possible because I am not using a
query to merge I am getting the message? When I tried it, I was on the
current record, click the button to pop up the merge form, select the
document and click merge and the message pops up but if I click Yes, it
does
what it is suppose to do anyway so I just thought it was like that because
I
wasn't running the query.

The above is 100% normal and good. I simply don't get that message at all
when using access 2003 + word 2003.

(as mentioned does this message occur when you use the sample download also,
or just in "your" application?)

Outside of that, it is seems to work fine and is quite easy to use and
install. If you guys can give me some specifics as to what I need to do to
fix it that would be great.

I am perplexed as to why you get this message and I don't.

Perhaps you try this on a different computer and see if it Behaves any
different?

 

[Stockwell43]

Albert,

It's not doing it on the template I downloaded but I did not test the
template yesterday. I only tried it in my application. However, in testing
both my application and the test template, it does not appear to be doing it
in either today. Maybe I needed to close the database to reset it or
something because I followed the same exact steps and the pop up did not
appear.

I truely love this mail merge, it really is super easy!!!

Thanks!!!