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
|