I am using the following macro to open a mail merged document. What I want to do is find a way to display a message when the query which am using for the mail merge contains no data and stop the module from opening the document. Is that possible, if yes please tell me how, coz I am no good when it comes to visual basic.
Dim objWord As Object
Set objWord = CreateObject("Word.Basic")
'objWord.AppMaximize "", 1 (optional)
Advance thank you for the help.