How to Prevent Mail Merge from Inserting Mailto Text in Word
Question details
Users experience an issue where mail merge results include unwanted 'mailto:' text alongside the email address when pulling data from Microsoft Access into Word.
- Product
- Microsoft Word, Microsoft Access
- Device & OS
- not provided
- Scenario
- Performing a mail merge in a Word document using an Access database as the primary data source.
- Observed behavior
- Email fields format incorrectly in the merged document, displaying a 'mailto:' prefix or underlying hyperlink value instead of a clean, plain-text email address.
Before making structural modifications to your database tables, ensure you create a complete backup of the Access file to prevent accidental data loss in the event of corruption.
Change the Access Email Field Type to Short Text
Modifying the field type in your Access database from Hyperlink to Short Text removes the underlying mailto properties, ensuring a clean plain-text merge in Word.
When Microsoft Access stores an email address as a Hyperlink, it includes hidden hyperlink properties like 'mailto:'. Converting the field to Short Text strips these extra attributes, leaving only the plain email address for your Word mail merge. Because database structure changes can sometimes cause issues in large databases, ensure you have backed up the file before proceeding.
Launch Microsoft Access, open your database, and locate the table containing the email addresses in the navigation pane. Right-click the table and select 'Design View'.
Find the row containing your email address field. Click on the drop-down menu in the 'Data Type' column next to it.
Select 'Short Text' from the Data Type drop-down menu instead of 'Hyperlink'.
Click 'Save' on the quick access toolbar. If you receive a warning message stating that data might be lost, confirm the change to proceed.
Open your Microsoft Word document, refresh the data source connection, and preview the mail merge results. The email addresses will now appear as plain text without the 'mailto:' prefix.
Use WPS Office for Seamless Mail Merge Projects
Avoid complex database field errors and formatting quirks by switching to WPS Office. WPS Writer seamlessly integrates with WPS Spreadsheets for a smooth, plain-text mail merge experience without the hassle of hidden 'mailto' hyperlink attributes.
- 1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' or 'Mail Merge' tab on the top ribbon.
- 2. Select Data Source: Click 'Open Data Source' and select your WPS Spreadsheet or Excel file containing the email addresses.
- 3. Insert Fields and Merge: Click 'Insert Merge Field' to place your email data, then select 'Merge to New Document' to generate pristine, plain-text results.
Frequently Asked Questions
Why does Word show 'mailto:' in my mail merge results?
When Word pulls an email address stored as a Hyperlink in an Access database, it imports the underlying HTML link properties. This includes the 'mailto:' prefix, which is normally hidden and used by web browsers or email clients to trigger new message windows.
Will changing the field type to Short Text delete my emails?
No, changing a Hyperlink field to Short Text in Access strips the clickable link properties but leaves the visible email address text intact. It is always recommended to back up your database first just to be safe.
Can I fix the mailto text directly in Word without touching the database?
While it is best to correct the data source directly to prevent recurring issues, you can sometimes toggle field codes in Word (by pressing Alt+F9) and manually adjust the merge field switches, though converting the Access field to Short Text is a far more reliable solution.
