VBA & Macro Problems

How to Create a Resident Suggestion Form Without Outlook or VBA

Elise Williams Oct 9, 2026 870 views

Question details

The user needs a cross-platform way to collect resident suggestions, as traditional Word forms using VBA to send Outlook emails fail on mobile devices and Macs.

How to Create a Suggestion Form That Works Without Outlook or Windows

Product: Microsoft Word
Device & OS: Windows, Mac, iOS, Android
Scenario: Creating a suggestion form for residents who use various platforms, making Windows-specific VBA scripts and Outlook integrations unusable.
Observed behavior: Word forms utilizing VBA to trigger Outlook emails do not function for users on non-Windows platforms or those without Outlook installed.

Before you start

Before exploring alternatives, finalize the list of questions or data fields you need to collect from your residents to ensure a smooth transition to a new format.

Solution 1Recommended

Use a Cloud-Based Online Form Service

The most effective cross-platform solution is to use an online form builder, which works seamlessly on all devices and handles email routing automatically.

Online forms are accessible via any standard web browser, making them fully compatible with Macs, smartphones, and tablets. They eliminate the need for users to have specific software like Microsoft Word or Outlook installed.

Most form services can be configured to automatically send an email notification to the administrator whenever a resident submits a new suggestion.

Choose an online form builder

Select a free or paid online form service such as WPS Form, Google Forms, or Microsoft Forms.

Design your form fields

Recreate your resident suggestion form by adding text boxes, multiple-choice questions, and dropdown menus.

Configure email notifications

Go to the settings menu of your chosen form builder and enable email notifications for new responses.

Share the form link

Copy the provided sharing URL or QR code and distribute it to your residents via email, text, or a community bulletin board.

Mobile Friendly: Online forms automatically adapt to smaller screens, ensuring an optimal experience for residents submitting suggestions from their phones.

Solution 2

Provide a Printable Offline Form

For residents who prefer not to use digital devices, providing a printable version of the form paired with a physical collection box is a reliable alternative.

Create Cross-Platform Forms Easily with WPS Office

WPS Office offers robust tools for creating interactive web forms and fillable PDFs that work seamlessly across Windows, Mac, iOS, and Android without relying on complex VBA code.

1. Install WPS Office: Download and install WPS Office on your computer or mobile device.
2. Access the Form feature: Open the application, navigate to the 'Tools' or 'Apps' section, and select 'WPS Form' (or 'PDF Edit' for fillable PDFs).
3. Build your suggestion form: Drag and drop your desired question fields, such as text boxes and multiple-choice options, into the form.
4. Distribute to residents: Generate a shareable link or distribute the fillable PDF directly to your residents for hassle-free submissions.

No VBA coding or Outlook configuration requiredFully compatible with Microsoft Word document formatsSupports seamless cross-platform form filling on mobile and desktopLightweight, free, and incredibly easy to use

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my Word VBA form work on a Mac or smartphone?

VBA macros that interact with the Windows OS or Microsoft Outlook rely on Windows-specific libraries (COM/ActiveX). These libraries are not supported on macOS, iOS, or Android, causing the scripts to fail.

Can I use a fillable PDF instead of a Word document for offline users?

Yes, exporting your Word document as a fillable PDF is a great cross-platform alternative. Users can fill it out on almost any device using a standard PDF reader without needing macro support.

How can I automatically receive form submissions without using Outlook?

By using online form builders, submissions are automatically collected in a secure cloud database. You can configure the form settings to send instant email notifications to your preferred inbox, completely bypassing the need for a local Outlook client.

Excel & Data Problems