DavidFromLafayette Posted March 28, 2012 Posted March 28, 2012 I have about 16 years of emails stored in about 30 individual PST files as part of our latest round of finger pointing and I told you that five years ago (yes Dilbert, Dogbert and the pointy haired boss really do exist). Does anyone have any suggestions on letting Outlook run say overnight load each PST, convert every email message to a PDF stored in seperate folders by year, month, and date of the message, and then close the PST files. Reason for doing this I figure it would be faster to do a keyword search on a series of PDF files indexed by Google Desktop than trying to load up all of these PST files and then letting Outlook do the seach. Any suggestons welcome thanks
water Posted March 28, 2012 Posted March 28, 2012 Should be possible - with some effort.Use my OutlookEX UDF andSet the default printer to a PDF printerAccess every PST file using function _OL_FolderAccessFind all mail items using _OL_ItemFindPrint each mail item to the default printer using _OL_ItemPrint My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Confuzzled Posted April 6, 2012 Posted April 6, 2012 How will attachments be handled? Will they be converted also? Does Adobe Acrobat Professional already provide similar functionality?
water Posted April 6, 2012 Posted April 6, 2012 Outlook only has one method to allow printing items: "Prints the Outlook item using all default settings.The PrintOut method is the only Outlook method that can be used for printing."Set the default settings to print attachments and then use function _OL_ItemPrint.Casn't test at the moment so you need to give it a try yourself.Another approach would be to safe all attachments and then use Word, Excel etc. to print them. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
DavidFromLafayette Posted April 18, 2012 Author Posted April 18, 2012 water: I think I finally got this working the way I want it, one question for you what is the fix for _ol_foldertree If StringStripWS($vOL_Folder, 3) = "" Then Return SetError(1, 0, "") being in the wrong location?
water Posted April 18, 2012 Posted April 18, 2012 Do you use version 0.7.0 (has bugs) or version 0.7.1 (should be bug free - fingers crossed) which I released today? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
DavidFromLafayette Posted April 19, 2012 Author Posted April 19, 2012 Version 0.7, will download and retest with 0.7.1
water Posted April 19, 2012 Posted April 19, 2012 Be sure to download the latest 0.7.1.1 - I had to update it again My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
DavidFromLafayette Posted April 25, 2012 Author Posted April 25, 2012 hopefully there is something simple and stupid i am doing wrong here. Below is a simple routine that in my mind would check for any open PST files and put them into an array and then go through and close all of those PST files. The array is displayed with all of the open PST files as folders that match the folder names in Outlook. But in the close section it doesn't recognize the folder name, see consolewrite output below code. Do you see anything obvious? thanks for looking #include <outlookex.au3> Global $oOutlook = _OL_Open() ConsoleWrite("asdf"&isobj($oOutlook) & @error & @extended & @CRLF) $bla = _OL_pstget($oOutlook) _ArrayDisplay($bla) For $k = 1 To $bla[0][0] ConsoleWrite("""" & $bla[$k][0] & """" & @CRLF) If Not $bla[$k][0] = "" Then $a = _OL_PSTclose($oOutlook, """" & $bla[$k][0] & """") ConsoleWrite("result" & $a & @error & @extended & @CRLF) EndIf Next _ol_close($oOutlook) asdf100 "SharePoint Lists" result02-2147352567 "2012 Jan to Jun Inbox" result02-2147352567
water Posted April 25, 2012 Posted April 25, 2012 Strip off the extra quotes: #include <outlookex.au3> Global $oOutlook = _OL_Open() ConsoleWrite("asdf" & IsObj($oOutlook) & @error & @extended & @CRLF) $bla = _OL_PSTGet($oOutlook) _ArrayDisplay($bla) For $k = 1 To $bla[0][0] ConsoleWrite($bla[$k][0] & @CRLF) If Not $bla[$k][0] = "" Then $a = _OL_PSTClose($oOutlook, $bla[$k][0]) ConsoleWrite("result" & $a & @error & @extended & @CRLF) EndIf Next _OL_Close($oOutlook) My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
DavidFromLafayette Posted April 25, 2012 Author Posted April 25, 2012 DOH!!!!!!!! Had them in there from when using path names d:documents..... thanks
water Posted April 26, 2012 Posted April 26, 2012 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
adom503 Posted April 27, 2013 Posted April 27, 2013 Using the print function, exporting mail messages of multiple pst files (as you told 30 pst's) into pdf file format is a bit hard. Also attachments are not exporting. If the matter is only for few messages then it is good to proceed. If mail meassges and pst files are several then a pst to pdf conversion app can save effort and time. Although it was paid but it saved my numerous hours and eases the whole work.Note - It allows to export emails with headers or without headers (It was best attribute for me)App Overview Pathhttp://www.pcvita.com/outlook-pst-to-pdf.html
water Posted April 28, 2013 Posted April 28, 2013 You are a bit late My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
austinm Posted December 9, 2013 Posted December 9, 2013 (edited) <snip> Edited December 9, 2013 by Melba23 Payware advert removed
water Posted December 9, 2013 Posted December 9, 2013 Another one trying to sell his product? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Moderators Melba23 Posted December 9, 2013 Moderators Posted December 9, 2013 austinm,We do notaccept payware adverts here - please do not do it again. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
karolinerose Posted October 7, 2016 Posted October 7, 2016 (edited) <snip> Edited October 7, 2016 by JLogan3o13
AutoBert Posted October 7, 2016 Posted October 7, 2016 On 9.12.2013 at 5:42 PM, Melba23 said: We do notaccept payware adverts here - please do not do it again. so why you do this also?
Moderators JLogan3o13 Posted October 7, 2016 Moderators Posted October 7, 2016 @karolinerose as mentioned, we do not accept payware advertisements here. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now