Opens new mail from Excel but won't send the message

[Gina_28 via OfficeKB.com]

Hello,

I have a macro that is pulling information from an Excel sheet, and for each
row, it opens a new Outlook mail message, with the specific information for
each person based on a general template for the message. The macro creates
the messages perfectly, and pulls in the information accurately, but will not
send the messages. So, I run my macro,and I now have 50 messages at the
bottom of my screen that I have to pull up and hit send for each one. Am I
missing a partial code that I need to add to the end of my macro? Or could
it be a firewall that is preventing it from sending?

Thank you very much!
Gina

 

[Sue Mosher [MVP-Outlook]]

Outlook version? Exactly what happens when the code executes your
MailItem.Send statement? Is your macro in Outlook or Excel?

 

[Gina_28 via OfficeKB.com]

I think I figured it out!! Was missing a (.Send) before the ('Or Use Display).


Thank you!!

Outlook version? Exactly what happens when the code executes your
MailItem.Send statement? Is your macro in Outlook or Excel?

Hello,

[quoted text clipped - 6 lines]

missing a partial code that I need to add to the end of my macro? Or could
it be a firewall that is preventing it from sending?