Office for Mac Issues

Fix Doug Robbins Merge Tools Errors 91 and 438 on Mac

Amos GikundaAmos Gikunda Nov 4, 2026 868 views

Question details

The user needs a solution for errors 91 and 438 occurring when merging emails with attachments using Microsoft Word Merge Tools on a Mac.

How to Fix Doug Robbins Merge Tools Errors 91 and 438 on Mac
Product
Microsoft Word
Device & OS
macOS
Scenario
Attempting to merge emails with attachments using Outlook and the Doug Robbins Merge Tools add-in.
Observed behavior
Microsoft Word displays Visual Basic runtime errors 91 and 438, halting the mail merge process.
Before you start

Verify your macOS and Microsoft Office applications are fully updated, as running outdated versions can sometimes cause unexpected Visual Basic compatibility issues.

Solution 1Recommended

Use a Browser-Based Mail Merge Alternative

Bypass the Mac VBA limitations by using a cloud-based spreadsheet solution, such as Google Sheets, to execute your mail merge with attachments.

The Doug Robbins Merge Tools add-in is a Windows-based solution that relies heavily on Windows-specific Visual Basic (VBA) code. Microsoft Office for Mac uses a different implementation of VBA, making this add-in fundamentally incompatible with macOS. This architectural difference directly causes runtime errors 91 and 438.

Since the tool cannot be fixed for local macOS execution, the best workaround is to utilize a browser-based mail merge extension that operates independently of local Office installations.

1
Open your preferred browser

Launch Safari, Chrome, or Firefox and navigate to Google Sheets.

2
Install a Mail Merge Add-on

Go to 'Extensions' > 'Add-ons' > 'Get add-ons', search for a highly-rated mail merge tool (like Yet Another Mail Merge or Mailmeteor), and install it.

3
Prepare your contact list

Format your recipient data in the spreadsheet, ensuring you have columns for email addresses and specific attachment URLs if required by the add-on.

4
Execute the merge

Run the installed add-on from the 'Extensions' menu to draft and send your emails with attachments directly through your linked Gmail account.

Use a Browser-Based Mail Merge Alternative
Mac Compatibility Limitation: Windows-specific COM add-ins and certain complex VBA macros will not function on macOS due to deep structural differences in how the operating systems handle application integrations.
Free Microsoft Office alternative

Try WPS Office for a Seamless Document Experience on Mac

If you are frustrated by compatibility errors and missing features in Microsoft Office on your Mac, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for Word documents, spreadsheets, and presentations without the heavy system requirements or subscription fees.

  1. 1. Download the Installer: Visit the official WPS Office website and download the macOS version.
  2. 2. Install WPS Office: Open the downloaded .dmg file and drag the WPS Office icon to your Applications folder.
  3. 3. Open and Edit: Launch WPS Office and directly open your existing Microsoft Word, Excel, or PowerPoint files to continue working seamlessly.
Fully compatible with Microsoft Word (.docx), Excel (.xlsx), and PowerPoint (.pptx) formats.Native optimization for macOS, ensuring smooth performance without legacy VBA translation errors.Built-in, user-friendly document processing and template management features.Free and lightweight, taking up minimal storage space on your Mac.Familiar user interface allows for immediate productivity with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why do I get VBA errors 91 and 438 in Word for Mac?

These errors usually occur because a macro or add-in was written specifically for Windows. It attempts to call commands, properties, or objects that simply do not exist in the Mac implementation of Visual Basic for Applications (VBA).

Can I install Doug Robbins Merge Tools on a Mac?

No, the Doug Robbins Merge Tools add-in relies on Windows COM integrations and specific Windows Outlook features. It is fundamentally incompatible with macOS and cannot be installed or run properly.

Are there built-in ways to mail merge with attachments on a Mac?

Microsoft Word for Mac supports basic mail merge functionality, but merging individual files as attachments natively is highly limited. Users typically need to rely on third-party Mac-compatible add-ins, AppleScript solutions, or cloud-based tools like Google Sheets.