If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Opens new mail from Excel but won't send the message
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...g-vba/200810/1 |
Ads |
#2
|
|||
|
|||
Opens new mail from Excel but won't send the message
Outlook version? Exactly what happens when the code executes your
MailItem.Send statement? Is your macro in Outlook or Excel? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gina_28 via OfficeKB.com" wrote: 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? |
#3
|
|||
|
|||
Opens new mail from Excel but won't send the message
I think I figured it out!! Was missing a (.Send) before the ('Or Use Display).
Thank you!! Sue Mosher [MVP-Outlook] wrote: 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? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...g-vba/200810/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reply accidentally opens Excel instead of using Outlook | Matt[_2_] | Outlook - General Queries | 4 | May 6th 08 12:14 AM |
Outlook 2003: selecting a mail folder automaticallyhighlights/selects/opens the first message in that folder | [email protected] | Outlook - General Queries | 2 | March 5th 08 11:14 PM |
how to send a html message from excel | Bruce | Outlook and VBA | 1 | September 2nd 07 12:43 AM |
Can I avoid the warning when I send mail from Excel | CH-DE-FDS APRIL | Outlook and VBA | 1 | May 7th 07 05:37 PM |
why my Excel attachment to email opens with Word? | AJ | Outlook - General Queries | 3 | August 23rd 06 07:08 PM |