email macro
Home > IT Answers > Exchange > email macro
Jraleccolin99
5 pts.
0
Q:
email macro
Outlook, Microsoft Excel, Excel macros
create amacro to send an email with Excelattachment
ASKED: Jun 1 2009  5:19 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Schmidtw
10505 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Where does this macro run? Is it from another application? Within excel itself?

Please try to be more specific.

-Schmidtw
Last Answered: Jun 11 2009  6:30 PM GMT by Schmidtw   10505 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Smf   40 pts.  |   Jun 15 2009  5:16PM GMT

If you have Outlook as your email and using Excel for the macro

Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject(”Outlook.Application”)
OutApp.Session.Logon

Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = strEmail
.Subject = strSubject
.Body = strbody
‘get each file to attach
.Attachments.Add strFile
.Display ‘Or use Send to send without looking at the email first
End With

Set OutMail = Nothing
Set OutApp = Nothing

 
0