With Mail
.Subject = "Today's Sales
.From = "khotsor@nissxx.com"
.To = "sales@nissxx.com"
.CC = ""
.BCC = ""
.textbody = "Hi All,"
End With
Mail.Send
Hi, I have been trying to automate email sending using gmail (CDO) with VBA. It works well when sending emails to individual email addresses. A problem arises when i send the group email (sales@nissxx.com); it just get stuck in the sent items (without displaying any error) and does not get delivered. sales@nissxx.com contains emails of all individuals in the sales team. what Am I doing wrong? do i need to redefine- the sales team in the macro?
.Subject = "Today's Sales
.From = "khotsor@nissxx.com"
.To = "sales@nissxx.com"
.CC = ""
.BCC = ""
.textbody = "Hi All,"
End With
Mail.Send
Hi, I have been trying to automate email sending using gmail (CDO) with VBA. It works well when sending emails to individual email addresses. A problem arises when i send the group email (sales@nissxx.com); it just get stuck in the sent items (without displaying any error) and does not get delivered. sales@nissxx.com contains emails of all individuals in the sales team. what Am I doing wrong? do i need to redefine- the sales team in the macro?
