View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mburkett mburkett is offline
external usenet poster
 
Posts: 23
Default Mail Sending Error

We are using the script below to send an email upon closing a
workbook. Some users are having issues on the .Send line and the email
never gets sent. All users are on the same exchange server with the
same domain with the same email program (Outlook 2003). Can anyone
think of settings or issues that may prevent this from sending?

With iMsg
Set .Configuration = iConf
.To = "
.CC = activepmeml
.BCC = ""
.From = activepmeml
.Subject = trdcheck & " trade(s) ready for execution in " +
activepm + "'s Equity Queue"
.TextBody = ""
On Error GoTo m:
.Send
End With