<div>
Please copy and paste the code here. Then select it and press the CODE button.
</div>


Please copy and paste the code here. Then select it and press the CODE button.

<div>
or at least post a link to the code ...
</div>


<div>
Here is the link. &nbsp;Cheers.<br />
<br />
<a href="https://www.experts-exchange.com/questions/26907191/How-to-parse-email-body-from-outlook-to-excel.html" rel="ugc">https://www.experts-exchange.com/questions/26907191/How-to-parse-email-body-from-outlook-to-excel.html</a>
</div>


Here is the link.  Cheers.

https://www.experts-exchange.com/questions/26907191/How-to-parse-email-body-from-outlook-to-excel.html [https://www.experts-exchange.com/questions/26907191/How-to-parse-email-body-from-outlook-to-excel.html]

<div>
Best you post the code your are running there, in case it accidentally got changed.<br />
<br />
I did notice one duplicate variable definition, did you delete one of those <b>SenderName</b> declarations?<br />
<br />

<pre><code id="code-20-42353121-1">    Dim SenderName As String, SentTime As String, MailBody As String, strFileName As String
    Dim MyArray() As String, SenderName As String, Address1 As String, Address2 As String</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


Best you post the code your are running there, in case it accidentally got changed.

I did notice one duplicate variable definition, did you delete one of those SenderName declarations?



    Dim SenderName As String, SentTime As String, MailBody As String, strFileName As String
    Dim MyArray() As String, SenderName As String, Address1 As String, Address2 As String

----------------------------------------

»bp

<div>
Hi. &nbsp;This is a direct copy of the code Sid had posted.
</div>


Hi.  This is a direct copy of the code Sid had posted.

<div>
Hi<br />
<br />
there is an example data, did you try running this one? I just check that .doc file it is pretty explanatory, perhaps you missed a step.<br />
<br />
Good Luck, <br />
Lyubo
</div>


Hi

there is an example data, did you try running this one? I just check that .doc file it is pretty explanatory, perhaps you missed a step.

Good Luck,
Lyubo

sshot-343.png

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have copied and pasted the script to parse data from Outlook into Excel but when I run the rule, I get 'Compile error: Next with For' and on the line 'Next i', the word Next is highlighted. &nbsp;Any help on this would be greatly appreciated.<br />
<br />
Cheers.
</div>
</div>


Hello

I have copied and pasted the script to parse data from Outlook into Excel but when I run the rule, I get 'Compile error: Next with For' and on the line 'Next i', the word Next is highlighted.  Any help on this would be greatly appreciated.

Cheers.

Sid's script posted on 2011-03-23

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.