Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lu Fischer   on Aug 17 In MS Office Category.

  
Question Answered By: Jennie Harris   on Aug 17

This will help you get started. You will also need a reference to the Microsoft
Outlook Object Library.

Dim Outlook As New Outlook.Application
Dim sSubject As String
Dim sTo As String


With Outlook.CreateItem(olMailItem)
.To = 'Email Address
.Subject = "Subject Title"
.Send
End With

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Using Excel to send email via Outlook Or get search suggestion and latest updates.


Tagged: