|
| 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
August 10th 06, 09:46 PM
posted to microsoft.public.outlook.printing,microsoft.public.outlook,microsoft.public.outlook.general,microsoft.public.outlook.program_vba,microsoft.public.outlook.usage
|
|||
|
|||
Help with Print Macro
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 |
|
#2
August 11th 06, 06:32 AM
posted to microsoft.public.outlook.printing,microsoft.public.outlook,microsoft.public.outlook.general,microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
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 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- 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
|
|
#4
August 11th 06, 05:18 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
Thanks for the macro code. I created the macro, changed my security
levels to allow it now I get a message saying that "items in this message are still loading. Please wait a moment and then try again.". The message opens, nothing prints, I get the error message and the email window remains open. I'm guessing Outlook needs more time to load the email before it can print it? I tried this with all different size emails (KB) and I got the same message. Thanks again, Dan Milly Staples [MVP - Outlook] wrote: 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
|
|
#5
August 11th 06, 05:47 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
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
|
|
#6
August 11th 06, 05:49 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
Am 11 Aug 2006 08:18:39 -0700 schrieb :
You could try to insert the command: DoEvents between the line .Display and .Printout. Are you using IMAP? -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Thanks for the macro code. I created the macro, changed my security levels to allow it now I get a message saying that "items in this message are still loading. Please wait a moment and then try again.". The message opens, nothing prints, I get the error message and the email window remains open. I'm guessing Outlook needs more time to load the email before it can print it? I tried this with all different size emails (KB) and I got the same message. Thanks again, Dan Milly Staples [MVP - Outlook] wrote: 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
|
|
#7
August 14th 06, 05:44 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
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 11 Aug 2006 08:18:39 -0700 schrieb : You could try to insert the command: DoEvents between the line .Display and .Printout. Are you using IMAP? -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Thanks for the macro code. I created the macro, changed my security levels to allow it now I get a message saying that "items in this message are still loading. Please wait a moment and then try again.". The message opens, nothing prints, I get the error message and the email window remains open. I'm guessing Outlook needs more time to load the email before it can print it? I tried this with all different size emails (KB) and I got the same message. Thanks again, Dan Milly Staples [MVP - Outlook] wrote: 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
|
|
#8
August 14th 06, 08:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
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
|
|
#9
August 15th 06, 12:20 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Help with Print Macro
What people object to is posting the same thing in multiple groups in
separate messages. If you post to a number of groups with 1 message then marking it read prevents you from seeing the post in other groups. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm wrote in message oups.com... 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
|
|
#10
August 15th 06, 08:05 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with Print Macro | [email protected] | Outlook - General Queries | 1 | August 11th 06 06:32 AM |
| vba macro to print email and attachments outlook 2000 | Dan over in IT | Outlook and VBA | 2 | June 7th 06 09:08 PM |
| D-Link DP-301U print server will not print from Outlook, OE, or Firefox | KLS | Outlook - General Queries | 2 | March 22nd 06 12:52 PM |
| D-Link DP-301U print server will not print from Outlook, OE, or Firefox | KLS | Outlook Express | 4 | March 22nd 06 04:14 AM |
| Macro to open, retrieve contents, print, and loop through process | Michelle Marie | Outlook and VBA | 2 | February 24th 06 10:39 AM |
Linear Mode
