Some Error on e-mail

L

leungkong

I use the following code to send e-mail.
It is work for most of my colleague. But some of my colleague got problem in
“.send “
Please help...Thanks a lot.

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = EmailAddr
.Cc = CcAddr
.Subject = esubject
.Body = ebody
.Attachments.Add (folder & SPfilename)
.Send ' <-- Problem in here!!!
End With
 
D

Daniel.C

Try replacing the ".send" line with ".display" and check if the
displayed mail is ok.
HTH
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending e-mails from specific email address 2
How to insert email signature from EXCEL VBA 5
Attaching more than one file to an email with VBA 2
CC the Sender in VBA Code 1
Mail a different file(s) to each person in a range 0
Send Outlook Email From Excel With Preview 7
Mail Multiple Sheets via PDF Q 5
Converting an Excel file to PDF Q 1

Top