Outlook VBA: Write to a file
Note: This is a post transferred from Laurii for historical and consolidation purposes.
I’m not a master in VB (I hate it actually) not in VBA, but it;s quicker to write something like a hack in VBA for outlook than in C#. So, here’s a tiny snapshot on how to write to a file in Outlook (my version is 2003):
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
Sub WriteToATextFile 'first set a string which contains the path to the file you want to create. 'this example creates one and stores it in the root directory MyFile = "c:\" & "whateveryouwant.txt" 'set and open file for output fnum = FreeFile() Open MyFile For Output As fnum 'write project info and then a blank line. Note the comma is required Write #fnum, "I wrote this" Write #fnum, 'use Print when you want the string without quotation marks Print #fnum, "I printed this" Close #fnum End Sub |
This is nice and funny, but you need to pass this as a parameter to functions to ensure that writing is done properly (sometimes at least)… You can do it like this:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
Sub Main() MyFile = "d:\" & "whateveryouwant.txt" 'set and open file for output fnum = FreeFile() Open MyFile For Output As fnum 'transmit the file as a parameter in a function WalkFolders (fnum) Close #fnum 'MsgBox "Outlook Set Up Succesfully" End Sub Sub WalkFolders(fnum) 'write something Write #fnum, "I wrote this" End Sub |
See? Easy!
A little experiment: If you find this post and ad below useful, please check the ad out :-)
[…] part of the program I’ve started, I had to perform a recursive walking of all sub-folders from a starting point in a .pst file. Code […]
Thanks, worked like a charm :)