Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / August 2008

Tip: Looking for answers? Try searching our database.

Managing messages before sending

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Markus - 26 May 2008 16:58 GMT
I have had to develop an email system without the use of Outlook, but would
like to see if I can integrate the same functionality using Outlook to take
advantage of the extensive OL email features.

My need is to be able to capture outgoing email before it is sent in order
to merge data from a table, and in order to save the final version of the
email message into a table.  The saved version must include any edits done by
the user before they clicked on send in OL.

As near as I can tell, this is not possible cause once you run OL from
another app, OL takes over and if user clicks on Send in their OL editor
(e.g., Word) the edited message goes out.  That is, when the user clicks on
Send and before the message goes out, I would like to replace certain strings
that I identify as table fields with info from the table, and  would like to
save that final msg version to a table.

Anyone have any ideas on how I might do this, or even if it would be possible?
Thanks in advance for any suggestions,
Mark
Sue Mosher [MVP-Outlook] - 26 May 2008 17:04 GMT
You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send.

Signature

Sue Mosher, Outlook MVP
  Author of Microsoft Outlook 2007 Programming:
    Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54

>I have had to develop an email system without the use of Outlook, but would
> like to see if I can integrate the same functionality using Outlook to take
[quoted text clipped - 15 lines]
> Thanks in advance for any suggestions,
> Mark
Markus - 28 May 2008 04:23 GMT
Sue,

Don't suppose you know of some vba code out there that may use Itemsend.  An
example would help me get started.

Thanks,
Mark


> You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send.
>
[quoted text clipped - 17 lines]
> > Thanks in advance for any suggestions,
> > Mark
Sue Mosher [MVP-Outlook] - 28 May 2008 04:42 GMT
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
   MsgBox Item.Subject
End Sub

As with any event, a good place to start is the topic in Help.

Signature

Sue Mosher, Outlook MVP
  Author of Microsoft Outlook 2007 Programming:
    Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54

> Sue,
>
[quoted text clipped - 5 lines]
>
>> You can use the Application.ItemSend event from the Outlook object model to work with the message after the user clicks Send.

>> >I have had to develop an email system without the use of Outlook, but would
>> > like to see if I can integrate the same functionality using Outlook to take
[quoted text clipped - 15 lines]
>> > Thanks in advance for any suggestions,
>> > Mark
Shri - 20 Aug 2008 21:31 GMT
Hello,
    I am trying to capture every mail item when I click on the "send"
button and append a disclaimer based on the receipient to the mailitem using
VBA. In this regard, I tried to implement your code below but the code is
never initiated. What am I doing wrong?

Thanks,
Srikanth

> Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
>     MsgBox Item.Subject
[quoted text clipped - 31 lines]
> >> > Thanks in advance for any suggestions,
> >> > Mark
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.