View Single Post
 
Old 04-29-2019, 05:01 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Code that uses Outlook.Application to initiate the email will only work with Outlook installed, but it isn't necessary for Outlook to be the default mail program. An alternative approach that should work on any Windows system, is to leverage the Windows Mail-API (aka MAPI). For some code to get you started on that, see:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=311
See also:
http://www.vb-helper.com/howto_excel..._students.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote