Thread: Help with Print Macro
View Single Post
  #10  
Old August 15th 06, 08:05 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
  
Posts: 1,885
Default Help with Print Macro
Am 14 Aug 2006 11:25:20 -0700 schrieb :

Add an obj.Close please.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Thanks the DoEvents insert helped. Now the macro opens the email &
prints it.

To end the macro I'd like for it to close the email window. What can
be added to this macro at the end to close the email window after
printing.


Also, is it not OK to post in multiple groups? I've done this in the
past in hopes of reaching more professionals like yourselves.


Thanks for your help,
Daniel

Michael Bauer [MVP - Outlook] wrote:
Am Thu, 10 Aug 2006 21:54:21 -0700 schrieb Milly Staples [MVP - Outlook]:

Milly, nice to meet you! I didnīt realize that Dan asked in several
groups.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Thanks for trimming the groups!

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Michael Bauer [MVP - Outlook] asked:

| Am 10 Aug 2006 12:46:55 -0700 schrieb :
|
| Public Sub PrintMail()
| Dim obj as Object
| Set obj=Application.ActiveExplorer.Selection(1)
| obj.Display
| obj.Printout
| End Sub
|
|
|| Hello,
||
|| I recently installed internet explorer 7 beta 3 update to my system
|| and I'm having a problem printing emails from the preview pane.
|| However I can print the email if I open it (doulbe click) and then
|| print it.
||
|| Doesn't look like microsoft has a fix for this yet so I was hoping
|| someone can help me with a work around - create a macro that would
|| open an email (already selected), print it and then close the email.
|| Pretty simple, but outlook doesn't have a macro recorder so I have
|| no idea how to write this.
||
|| So can someone provide me with the code I need to do this. Again the
|| situation would be that I have the email already highlighted in the
|| preview plane and I'd like to have the marco open the email, print it
|| and then close it.
||
|| Thanks,
|| Dan
Ads