PJ_KD
asked on
How to bulk print only the excel 2007 file attachments within an Outlook folder
I am receiving 300 emails a week that each contain an Excel attachment. The emails are automatically stored in a folder within Outlook through a rule that I already setup. I need to print only the attachments which are Excel spreadsheets. I do not want to print the emails themself. Is there a one-click way to do this or maybe a macro that can be developed that can be excuted within Outlook? Thank you.
You can purchase Print Manager Plus (http://www.softwareshelf.com/) which will do this automatically. We use it and it's very configurable and reliable.
Sorry, ignore my first post. What you want is Automatic Email manager: http://www.namtuk.com/auto_email_manager.aspx
Don't know why Print Manager PLus came to mind....
Don't know why Print Manager PLus came to mind....
http://office.microsoft.com/en-us/outlook-help/print-an-attachment-received-in-a-message-HP001232905.aspx
Rob
Select multiple email messages, then follow link above.
Rob
Select multiple email messages, then follow link above.
Do this first though - click to open single attachment (make it Excel) UNCHECK the Always ask before opening this type of file.....
Rob
Then try with 2 or 3 email messages selected with exel attachments
Rob
Then try with 2 or 3 email messages selected with exel attachments
ASKER
varbarsoun-I don't want to buy a product or introduce another product to our environment
rjwesley-The solution you proposed prints the email page in addition to the attachment. I don't want to print the email since I don't need it and don't want to waste the paper. I couldn't find the UNCHECK that you mentioned in your solution to not ask before opening the file
rjwesley-The solution you proposed prints the email page in addition to the attachment. I don't want to print the email since I don't need it and don't want to waste the paper. I couldn't find the UNCHECK that you mentioned in your solution to not ask before opening the file
Hi, PJ_KD.
I wrote an EE article about how to do this. Here's a link to it.
https://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_2924-Automatically-Printing-Saving-Emails-Attachments-in-Outlook.html
I wrote an EE article about how to do this. Here's a link to it.
https://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_2924-Automatically-Printing-Saving-Emails-Attachments-in-Outlook.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rob,
I am using the File | Print. The print range does eliminate the printing of all of the cover pages with the exception of the first page. Since each spreadsheet is an .xls file and they are being opened by Excel 2007, there is a prompt after opening each file as to whether to Save it, not save or Cancel for each file opened. Since there will be 300 at a time, is there some way to suppress the Save prompt?
Kathryn
I am using the File | Print. The print range does eliminate the printing of all of the cover pages with the exception of the first page. Since each spreadsheet is an .xls file and they are being opened by Excel 2007, there is a prompt after opening each file as to whether to Save it, not save or Cancel for each file opened. Since there will be 300 at a time, is there some way to suppress the Save prompt?
Kathryn
When you double click an single email message with an xls or xlsx attachment, is there not a prompt as in the link. This should occur when you double click a file attachment to OPEN the file within Excel, not PREVIEW the file within Outlook.
An image like this should pop up (http://www.daleisphere.com/wp-content/uploads/image322.png) - this is where you want to remove the check mark beside "Always ask before opening this type of file....."
Rob
An image like this should pop up (http://www.daleisphere.com/wp-content/uploads/image322.png) - this is where you want to remove the check mark beside "Always ask before opening this type of file....."
Rob
ASKER
Rob, I had tried that but still got the same prompt while printing the spreadsheets. I have developed an alternative solution through an Outlook macro with code borrowed from various sources. It does the same thing as your recommended solution except it continues to print even though there are windows open (one for each spreadsheet) to Update (yes, no, or cancel). Maybe there is some code trap that can be added to this to bypass the Windows prompt for each printed file. Here is that code:
Kathryn
Kathryn
Public Sub PrintAttachments()
Dim Inbox As MAPIFolder
Dim Item As MailItem
Dim Atmt As Attachment
Dim FileName As String
Dim i As Integer
Dim xlApp As Excel.Application
Dim wb As Excel.Workbook
Set Inbox = GetNamespace("MAPI").GetDefaultFolder(olFolderInbox).Parent.Folders.Item("BiG")
For Each Item In Inbox.Items
For Each Atmt In Item.Attachments
FileName = "C:\BiGTemp\" & Atmt.FileName
Atmt.SaveAsFile FileName
Set xlApp = New Excel.Application
Set wb = xlApp.Workbooks.Open(FileName, , ReadOnly)
wb.PrintOut
xlApp.Quit
Next
Next
Set Inbox = Nothing
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
BlueDeveilFan - I just saw that you had submitted a response but had missed it earlier so I did not see your solution until I had developed this one. I don't know whether your solution would have solved my problem or not.
No problem.
ASKER
I am fine with closing this.
ASKER
I have the answer I need now