The cool thing about this is that you can create up any string you want to customize a full email message and assign it to the strBody variable. Piece together components of the message by using the & string to insert data from any of the Microsoft Excel sheets right into the email message, just like shown above.
I’m working with Excel sheets that contain a lot of email addresses as well.
When updating a field, it turns the email address in a clickable “mailto” link and when I’m not careful when clicking, it opens up a new email in Outlook.
Excel Mail List
As I have no intention to email anyone directly from these lists, but do work a lot with these sheets, this is getting annoying quite fast.
Is there any way to disable this behavior in Excel?
Excel Mail Vba
An Excel mailing list can be shared with Outlook for contact management and email blasts, while the same list can merge with Word to create form letters or address and filing labels. To ensure the most flexible use of your Excel list, keep in mind a few best practices. Creating Your Excel Mailing List Step 1. Excel Printing and Mailing is an independent provider of direct mail services that is not associated, sponsored, or otherwise approved by the United States Postal Service to provide these services. EDDM®, Every Door Direct Mail ® and EDDM ® Retail are trademarks of the United States Postal Service. Your e-mail has been migrated to Mercury Network. Please visit to access your e-mail and bookmark/save the new site. While the appearance of Mercury’s webmail is a little different, the overall layout and organization is generally the same. Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents, spreadsheets, and presentations online, in OneDrive.
The automatic conversion of typed email address into clickable mailto links in Excel is controlled by the same AutoCorrect option that turns typed internet addresses (URLs) into clickable hyperlinks.
If you actually need to work with the data rather than to follow links, you can turns this function off or use an alternative clicking/selection method for cells that contain hyperlinks.
Disable automatic hyperlink feature
Excel Mail Merge Labels
To disable the automatic hyperlink feature in Excel choose;
- File-> Options-> Proofing-> AutoCorrect Options…-> AutoFormat As You Type-> uncheck: Internet and network paths with hyperlinks
Note: If this option is left enabled and AutoCorrect changes the address into a hyperlink, you can press CTRL+Z to directly undo the change.
AutoFormat can recognize email address and convert them to Mailto links.
Alternative clicking or selection method
If you don’t want to turn of the feature (for instance when the recipient of the Excel sheet needs to be able to click on the links), you can also use one of the following alternative clicking or selection methods;
Excel Mail Login
- Click and hold down the mouse button bit longer on the hyperlink. This will select the cell instead of activate the hyperlink.
- Make the column a bit wider so there is white space within the cell so you can click or double click there without activating the hyperlink.
- Click in a nearby cell that doesn’t have a hyperlink and use the arrow keys on your keyboard to select the hyperlinked cell. You can then press F2 to edit the contents.