This macro was created by merging the macro above with the macro at " Outlook VBA: Work with Open Item or Selected Item". This macro looks for the pattern in each message in the folder and writes the found values, subject, and received time to the Excel sheet. Run the macro on all messages in the folder (In my testing, the line wrapped in the cell automatically using the shorter pattern.) If you need to throw the entire line into one cell, you'll use the following code snippet. ' each "(\w*)" and the "(\d)" are assigned a vText variable Set Reg1 = CreateObject("VBScript.RegExp") RCount = xlSheet.Range("B"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |