Recent content by Derek

  1. D

    Outlook macro to extract data from emails to .txt file

    Can you tell me what change needs to be made ? I tried different ways at my end but no luck :(
  2. D

    Outlook macro to extract data from emails to .txt file

    Hi All, 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...
  3. D

    Extract email body contents into .txt file

    Yes It worked fine . Added another replace command to replace chr(34 ) with "!!". Thanks so much :)
  4. D

    Extract email body contents into .txt file

    Thanks . Can you please send me a line of code ?
  5. D

    Extract email body contents into .txt file

    Where shall I add another replace ? I just need to replace double quotes with '!!' sign for email part only .
  6. D

    Extract email body contents into .txt file

    Hi guys, 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...
  7. D

    Solved Remove 2 blank characters from account number in pdf file name

    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?
  8. D

    Solved Remove 2 blank characters from account number in pdf file name

    Hi guys, 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 . I...
  9. D

    Check if the first 9 characters of subject line is 'FORMIMAGE'

    Yes I have tried that as well nut no joy :( For I = (SubFolder.Items.Count - 1) To 0 Step -1 'Set E_Mail = strInboxFolder.Items(I) Set myItem = SubFolder.Items(I)
  10. D

    Check if the first 9 characters of subject line is 'FORMIMAGE'

    I tried to change the For loop to below but it's still missing few emails : For Each Item In SubFolder.Items 'If TypeOf Item Is Outlook.MailItem Then Set oMail = Item
  11. D

    Check if the first 9 characters of subject line is 'FORMIMAGE'

    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...
  12. D

    Check if the first 9 characters of subject line is 'FORMIMAGE'

    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 .
  13. D

    Check if the first 9 characters of subject line is 'FORMIMAGE'

    Hi guys, 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...
  14. D

    Extracting email into pdf format

    Hi guys 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...
  15. D

    Outlook VBA code to check if mailbox exists

    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,
Top Bottom