Unable to Run MS Word Macro

Unable to Run MS Word Macro

PROBLEM

  • Unable to run MS Word macro WMPreviewMessageDDE.
  • Unable to run MS Word macro WMPrintLetterStationeryDDE: Exception has been thrown by the target of an invocation.
  • Unable to run MS Word Macro WMPrintEmailDDE.
  • This file could not be found. ("c:/users/<username>/.../b2-Itrs.dot")

CAUSE

These errors are caused by Word pointing to the incorrect Word Templates folder for Gorilla. 
Cloud users can simply uncheck the Preview box to avoid this error when sending emails or printing, but will still want to verify the settings below.

SOLUTION

  1. Check your Word settings first to make sure everything is set up correctly.
    1. Close Gorilla, Outlook, and all Word documents.
    2. Open a blank Word document.
    3. Click File->Options.
    4. On the General tab make sure the Username is filled in and there are two or three capital letters in Initials.
    5. Scroll down to the bottom and uncheck the box “Open Email attachments and other uneditable files in Read Only view.”
    6. On the left, select “Advanced.”
    7. Scroll down to the bottom under General--click “File Locations.”
    8. Double click on “User Templates.”
    9. Update the path so that it points to C:\Program Files (x86)\Bill Good Marketing\Gorilla CRM FS 4.3\Word Templates.
      • Note: This path will be different based on what version of Gorilla you are using.
      • For a 32 bit computer you will use the following instead: C:\Program Files\Bill Good Marketing\Gorilla CRM FS 4.3\Word Templates.
    10. Click “OK.”
    11. Close out of MS Word and try the message again.
  2. For emails, confirm that you are not putting any double quotation marks in the subject line (single quotation marks are fine).

If the problem persists: make sure the View in Word is set to Print Layout, not Full Screen Reading or Web Layout.

See Also

To reset Word settings back to defaults, follow the Microsoft article How to reset user options and registry settings in Word.

Note: This may be useful if updating your Word settings is not correcting the issue.



    • Related Articles

    • Run Macro Error -2147352567 Method ‘~’ of objective ‘~’ failed

      PROBLEM This method or property is not available because the current selection is not a graphic. Microsoft Word document “b2-ltrs.dot” opens and says: Bill Good Marketing, Inc., MS-Word 97/2000 Letters Template for Gorilla 2.0 – DO NOT MODIFY. ...
    • Unable to Attach B2-Ltrs.dot to Document

      PROBLEM Scenario 1 When sending a customized message from Gorilla, you finish the message, save the changes then click to continue printing, and get the message "Unable to attach B2-ltrs.dot file to [file name].doc." Scenario 2 When attempting to ...
    • Run Macro Error "Error 438" Object Doesn't Support This Property or Method

      PROBLEM When printing a script/checklist you get: Run Macro Error: Error #438: Object doesn't support this property or method  SOLUTION Open the Document Manager (Messaging>Document Manager) Click on the drop down at the top left and choose ...
    • Unable to Send Email Message

      PROBLEM When trying to send an email message from Gorilla, you get the message:  Unable to send email message: Retrieving the COM class factory for component with CLSID {741BEEFD-AEC0-4AFF-84AF-4F61D15F5526} failed due to the following error: ...
    • Disable automatic updates in Word

      Recently, Microsoft has released an update to Word that has caused problems with the macros not being able to delete blank lines in the merge fields.  Most people have not yet received this update; therefore, it is important that you prevent the ...