The below macro works fine and extract the data from emails into .txt file . The only thing not working is question number 3 "Do you think you’ll be able to start making your full monthly payments again after 3 months?" has got apostrophe sign and the macro is not considering it a...
I got the script to extract data from email body to .txt file working . But there is email field in the body which contains email address and it's getting stored into .txt file in the format HYPERLINK "mailto:A11x@hotmail.co.uk"A11x@hotmail.co.uk
Is there any way I can change double...
Sorry I added Len function to test the number of characters in account number . I have taken it off now .
There are 2 spurious characters at the start of the filename . don't think they are spaces but some other special characters . How can I take off first 2 characters from the string?
I have written outlook vba code to save all the emails down in pdf format in a folder with specific naming conventions . The PDF file names need to start with Account number but when the files get saved down then there are 2 blank characters appearing in the beginning of file name .
Gasman , I have added a line of code to check for first 9 characters of subject line . Not sure why the FOR loop (For I = 1 To SubFolder.Items.Count) is not picking up the emails from top to bottom . It's randomly picking the emails and ignoring few as well
Public Declare Function...
Guys - I know I can use Left function but where in the code it needs to be used as I want the code to check the first email subject line and if it's not 'FORMIMAGE' then ignore it and move to the next one .
Any help will be much appreciated .
I got the following code which will check the mailbox and extract data from them into .pdf and .txt file.
I have to amend the script so it will check the subject line for each email and it should extract data from only those emails whose subject line start with 'FORMIMAGE' and ignore...
I want to use outlook vba to save the email down as .pdf format . There is a 'Apps' folder within the mailbox so all the emails in that mailbox need to be converted into .pdf file and save down in a dedictaed folder . To note there are no attachments in the emails so just the body...
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 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...
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, "")