DavidFromLafayette

Convert 30 PST files to PDF by individual email message

20 posts in this topic

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

Share this post


Link to post
Share on other sites



Should be possible - with some effort.

Use my OutlookEX UDF and

  • Set the default printer to a PDF printer
  • Access every PST file using function _OL_FolderAccess
  • Find all mail items using _OL_ItemFind
  • Print each mail item to the default printer using _OL_ItemPrint

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

How will attachments be handled? Will they be converted also?

Does Adobe Acrobat Professional already provide similar functionality?

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Version 0.7, will download and retest with 0.7.1

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

DOH!!!!!!!!

Had them in there from when using path names d:documents.....

thanks

Share this post


Link to post
Share on other sites
;)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 Path

http://www.pcvita.com/outlook-pst-to-pdf.html

Share this post


Link to post
Share on other sites

You are a bit late ;)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#15 ·  Posted (edited)

<snip>

Edited by Melba23
Payware advert removed

Share this post


Link to post
Share on other sites

Another one trying to sell his product?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

austinm,

We do notaccept payware adverts here - please do not do it again. :naughty:

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

#18 ·  Posted (edited)

<snip>

Edited by JLogan3o13

Share this post


Link to post
Share on other sites
On 9.12.2013 at 5:42 PM, Melba23 said:

We do notaccept payware adverts here - please do not do it again. :naughty:

so why you do this also?

Share this post


Link to post
Share on other sites

@karolinerose as mentioned, we do not accept payware advertisements here.


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now