Thread: Email
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default Email

Hi Alvin,
i haven't looked at mailing or mailing objects but i would try to surround
the code with DisplayAlerts

application.DisplayAlerts=False
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
.Display
.Send
End With
application.DisplayAlerts=True

"Alvin Hansen" wrote:

Hi
I use this to send a email in excel
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg

.Display

.Send

End With
Its allright but there come a warning from outlook thats also allright but
if i here cancel the email the system goes down , how can i get arounf this?
MAybe a If -else -then or something like that?

Alvin