Suppress Error Messages

  • Hi All:
    Not quite sure if Access forum is the right place to post but still will give it shot here. I have a procedure in Access that creates a MailMerge on Word Document, Prints out "formated" pages and Exits Word Application. My problem is with Printing. Document margins exceed printer allowed margins and I am flagged with an error message. To get suppress any error messages I used .DisplayAlerts property:

    Code
    wrdApp.DisplayAlerts = wbAlertsNone


    But still am getting these types of error messages. I also used .DisplayScreenTips method and still no luck.

    Code
    wrd.AppDisplayScreenTips = False


    I realy need to automate the whole process(creting mailmerge, printing, closing word app) as much as possible. Right now the only problem that I am having is with these messages.


    Thank you in advance.


    ~j.v.a.

  • Re: Suppress Error Messages


    j.v.a.,
    I have had a quick browse and found several people all asking similar questions about word and Display Alerts. Several solutions actually appeared to suggest using DisplayAlerts=False


    I accept that that is not the expected syntax of the Word.DisplayAlerts, however might be worth a go?


    The most promising link from a Google search was blocked by my company's filter, but here is the link.
    http://homepage.hispeed.ch/cindymeister/mergfaq2.htm


    Good luck,


    Alan.

  • Re: Suppress Error Messages


    Alan, appreciate your help on this one and thank you for the link. Unfortunately (for some reason) .DisplayAlerts does not work in my case . I am still flagged with message "The margins of section are set outside of printable area..."
    ~j.v.a.

  • Re: Suppress Error Messages


    Still am not certain how to control these types of messages in code. I simply reformatted template document and problem got solved =)
    ~j.v.a.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!