PC Review


Reply
Thread Tools Rate Thread

Create a Rule or Macro to Print Emails after Sending

 
 
=?Utf-8?B?TWFydGluIEJveXM=?=
Guest
Posts: n/a
 
      2nd Aug 2007
I want to create a rule or write a macro in Outlook that allows me to choose
if I want to print the email after it has been sent.

Ideally, after sending the email I would like a message to pop up that asks
if I would like to print the email and I could choose either 'Yes" or 'No'.

Dose anyone have a solution?

Thanks,
Martin Boys.
 
Reply With Quote
 
 
 
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      2nd Aug 2007


I don't have the solution for you, but if you want to write the code:

use the ItemAdd event of the SentItems folder. The VBA help file provides
you with a sample for ItemAdd. In that event use the MsgBox function with
the parameter vbYesNo. If the user clicks Yes then call the item's PrintOut
property.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Wed, 1 Aug 2007 19:02:04 -0700 schrieb Martin Boys:

> I want to create a rule or write a macro in Outlook that allows me to

choose
> if I want to print the email after it has been sent.
>
> Ideally, after sending the email I would like a message to pop up that

asks
> if I would like to print the email and I could choose either 'Yes" or

'No'.
>
> Dose anyone have a solution?
>
> Thanks,
> Martin Boys.

 
Reply With Quote
 
=?Utf-8?B?TWFydGluIEJveXM=?=
Guest
Posts: n/a
 
      3rd Aug 2007

Thanks for your help. I have experience wiritng macros in Excel, but never
in Outlook. Do you possibly have an example of some code I could copy?



"Michael Bauer [MVP - Outlook]" wrote:

>
>
> I don't have the solution for you, but if you want to write the code:
>
> use the ItemAdd event of the SentItems folder. The VBA help file provides
> you with a sample for ItemAdd. In that event use the MsgBox function with
> the parameter vbYesNo. If the user clicks Yes then call the item's PrintOut
> property.
>
> --
> Viele Gruesse / Best regards
> Michael Bauer - MVP Outlook
> Organize eMails:
> <http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
>
> Am Wed, 1 Aug 2007 19:02:04 -0700 schrieb Martin Boys:
>
> > I want to create a rule or write a macro in Outlook that allows me to

> choose
> > if I want to print the email after it has been sent.
> >
> > Ideally, after sending the email I would like a message to pop up that

> asks
> > if I would like to print the email and I could choose either 'Yes" or

> 'No'.
> >
> > Dose anyone have a solution?
> >
> > Thanks,
> > Martin Boys.

>

 
Reply With Quote
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      3rd Aug 2007


This sample prints new e-mails:
http://www.vboffice.net/sample.html?...showitem&pub=6

In Application_Startup replace olFolderInbox by olFolderSentItems. In the
print procedure replace the Mail.Unread by the mentioned MsgBox, which is
the same funtion as in Excel.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 2 Aug 2007 19:32:04 -0700 schrieb Martin Boys:

> Thanks for your help. I have experience wiritng macros in Excel, but never
> in Outlook. Do you possibly have an example of some code I could copy?
>
>
>
> "Michael Bauer [MVP - Outlook]" wrote:
>
>>
>>
>> I don't have the solution for you, but if you want to write the code:
>>
>> use the ItemAdd event of the SentItems folder. The VBA help file provides
>> you with a sample for ItemAdd. In that event use the MsgBox function with
>> the parameter vbYesNo. If the user clicks Yes then call the item's

PrintOut
>> property.
>>
>> --
>> Viele Gruesse / Best regards
>> Michael Bauer - MVP Outlook
>> Organize eMails:
>>

<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
>>
>> Am Wed, 1 Aug 2007 19:02:04 -0700 schrieb Martin Boys:
>>
>>> I want to create a rule or write a macro in Outlook that allows me to

>> choose
>>> if I want to print the email after it has been sent.
>>>
>>> Ideally, after sending the email I would like a message to pop up that

>> asks
>>> if I would like to print the email and I could choose either 'Yes" or

>> 'No'.
>>>
>>> Dose anyone have a solution?
>>>
>>> Thanks,
>>> Martin Boys.

>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create an auto reply rule/macro that wont create a new mess squalltheonly Microsoft Outlook Discussion 4 15th Nov 2008 04:03 PM
Can I create a rule for a message I'm sending out Bradley Burton Microsoft Outlook Discussion 1 11th Sep 2008 06:19 PM
Create sending rule bodowspam@charter.net Microsoft Outlook Discussion 6 31st Jul 2007 06:18 PM
Can I set a rule to prevent sending emails with no subject =?Utf-8?B?TWFyY2hfSGFyZQ==?= Microsoft Access 2 15th Apr 2005 03:29 AM
print rule after sending mohamed abdel fatah Microsoft Outlook 0 30th May 2004 05:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:38 AM.