Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cameron Evans   on Nov 12 In MS Office Category.

  
Question Answered By: Steve Boyd   on Nov 12

Use the following macro and assign it to the button.

Sub Test()
Dim x As Outlook.Application
Dim y As Outlook.MailItem
Set x = CreateObject("Outlook.Application")
Set y = oLapp.CreateItem(0)
With y
.Subject = ""
.CC = ""
.To =
.Body =""
.Attachments.Add '(path to the attachment,either hard coded or
variable)
.Display
End With
Set x = Nothing
Set y = Nothing
End Sub

You have to enable the Microsoft Outlook x(is the version) Library
from Tools-References in your VB Editor to be able to use this.

Share: 

 

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

 


Tagged: