Search results

Hi guys, I want to write the validation to check if the following mailbox exist in my outlook? Can anyone please help me with this? Dim olRecip As Outlook.Recipient Set olRecip = mynamespace.CreateRecipient("Derek.Smith@boi.com") Thanks,

Thanks gasman . What changes do I need to make in my macro so that we can extract data to excel file ? Suppose in one extract there are 100 emails so when the macro is run then it will extract data from those 100 emails to one excel workbook and save it down with unique name. Now when we do...

Guys, one more question . At the moment the macro extracts data from email to .txt file and there is separate .txt file for each email. How can I change the code so that data is extracted into excel file instead and there is just one excel file stored in a location where all the data gets...

Thanks Gasman.

Gasman , I have deleted that post . Can you please amend this line of code accordingly ? strRowData = Replace(Replace(Replace(Trim(strRowData & Trim(messageArray(j)) & "|"), vbCr, ""), vbLf, ""), vbTab, "")

Thanks . How this can be used in a macro so it will scroll through the emails in a dedicated folder and extract xml data from the email to a .txt file or excel spreadsheet ?

I’m not sure if xml data in a file or email body yet. How do we use importXML method ? Can this be used in outlook ? Can you give me some examples if you got ? Thanks

I got the code to extract data from the email which has structured format but how can we extract data from xml file format ??

Hi guys , I have recently made an outlook script working to extract data from email body to .txt file . For that one the email body contents were in structured format . Just wonderingcan we extract data from the outlook emails that has a HTML table in the email and a XML file that’s sent to...

Hi guys, I have another query from the stakeholders . How can we extract data from the outlook emails that has a HTML table in the email and a XML file that’s sent to the designated mailbox. The mailbox will need to be managed but is there an a way we could to do some sort of extract with the...

I have amended my line as below but it doesn't take off tab spaces strRowData = Replace(Replace(Replace(Trim(strRowData & Trim(messageArray(j)) & "|"), vbCr, ""), vbLf, ""), vbTab, "")

Guys, the users have got a new folder without '&' sign and the above issue has been resolved and the script works fine with no issues. The other thing I came across is some emails have weird formatting with extra spaces(tab spaces) in it and the below code doesn't take them off although I have...

Thanks guys , during testing we found out something that if the shared mailbox has & sign in it then the script doesn’t recognise the mailbox and doesn’t do any processing . Any mailbox without & sign work fine Set olRecip = mynamespace.CreateRecipient("a1&bc@gmail.com")

Thanks guys , my code is working fine now . At the moment it looks into all the emails in the folder . Can I add a filter so it will look into the emails whose subject line starts with 'Account holder details' ? Thanks

Hi guys, Please see below my updated code . I have actioned 1st question so my code now looks into the shared folder but my 2nd point moving item to complete folder doesn't work as expected . There are 2 emails in total in ExtractEmail folder and the code moves first email to Complete folder...

Guys, one more question . Presently when the VBA script is run then it looks into the folder you are currently in and then extract data from that folder . How can I amend the code as below : 1. so it will look into a specific email folder and extract emails from that particular folder only. 2...

Thanks so much Arnelgp. It actually worked. I had to delete extra concatenation bit as below and it works like a charm. strRowData = Replace(Replace(Trim(strRowData & Trim(messageArray(j)) & "|"), vbCr, ""), vbLf, "")

Hi Arnelgp, Please see attached the text file. It's now showing all the values duplicating multiple times .

Thanks Cronk , can you please let me know exactly where I need to make the change ? Can you please update the code for me ? Thanks

Cronk, The code doesn't truncate blank spaces and that's why data is not showing in one line . Please see attached my text file and updated code below: Sub Extract() On Error Resume Next Set myOlApp = Outlook.Application Set mynamespace = myOlApp.GetNamespace("mapi")...