A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 15th 08, 12:50 AM posted to microsoft.public.outlook.program_vba
Gina_28 via OfficeKB.com
external usenet poster
 
Posts: 2
Default 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  
Old October 15th 08, 02:45 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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  
Old October 15th 08, 02:58 AM posted to microsoft.public.outlook.program_vba
Gina_28 via OfficeKB.com
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.