Recent content by wmiles

  1. W

    Outlook body to Excel Document

    Hi Diane It basically just repeated the first value, it did repeat it the same amount of times as emails that had been processed. I'm happy for any help so whenever you get a chance to change the code i'm happy. Its not mega urgent and if you feel its too much work just say. Regards...
  2. W

    Outlook body to Excel Document

    Sorry got that wrong, it processes all items, but only does the catagories colour on the selected item. It processed as follows. P130600522 100329 ACTI099 201 199.5 P130600522 100329 ACTI099 201 199.5 P130600522 100329 ACTI099 201 199.5 P130600522 100329 ACTI099 201 199.5...
  3. W

    Outlook body to Excel Document

    I tried the XlWB.Save and that caused the same error. It still only seems to process the message you are highlighting.
  4. W

    Outlook body to Excel Document

    This is the current code, I'm getting a message with the following. SGNCCIPS.xls is already open, reopening will cause any changes you made to be discarded. do you want to reopen sgnccips.xls Yes / No. This is on a dialogue box. Also, it only seems to be running on messages selected...
  5. W

    Outlook body to Excel Document

    Hi Diane I've run it again in the inbox and I got the error Compile Error: End If without block if End If Set Reg1 = Nothing Set xlApp = Nothing Set xlWB = Nothing Set xlSheet = Nothing End Sub
  6. W

    Outlook body to Excel Document

    Hi Diane Not sure if I went wrong somewhere, I clicked on tools, categorize, added a category of processed with a colour. I then run the rule again and nothing happened. I used the new code as above.
  7. W

    Outlook body to Excel Document

    Hi Diane Thanks for all your information This is the current code, I'm not sure where to add / remove the bits you have suggested. I'm a bit clueless when it come to these things, I work in an office doing paperwork. That's why I appreciate the help you are giving me...
  8. W

    Outlook body to Excel Document

    Its definitely an issue with the rule to run a script, they seem to run at the same time, I thought that outlook processed message one by one but it doesn't seem to. it causes confusion for the script. Does anyone know if its possible to run a rule message by message and possibly put a delay of...
  9. W

    Outlook body to Excel Document

    Hi Diane Sorry to bother you again, I've run into a little issue, it all works perfectly if only one email is received at a time, the problem I have is that if it receives maybe 10 - 20 emails at the same time it seems to copy the same line several times, its like it cant cope with it so...
  10. W

    Outlook body to Excel Document

    Superb, all working now, I've got to move it into a working environment tomorrow. Thank you for all your help today, I'm sorry if I've taken up too much of your time. I really appreciate everything you have done. In the long run the script will save me so much time not having to go through...
  11. W

    Outlook body to Excel Document

    Hi Diane Not sure if I went wrong somewhere. I tried > Pattern = "((P130\w*)\s*(\w*)\s*(\w*)\s*(\w*)\s*[\d-\.]*))" and > Pattern = "((P130\w*)\s*(\w*)\s*(\w*)\s*(\w*)\s*(\d-\.)*))" Both produced errors.
  12. W

    Outlook body to Excel Document

    Wow Diane we are almost there, I have I think one last question, as these are prices they go to 2 decimal places for instance 41.06. I change the code to use d* but its only showing as 41 not 41.06, Any ideas how to fix that. 'we could use d instead of w- if last value is more...
  13. W

    Outlook body to Excel Document

    Hi Diane It works brilliant it imports perfectly into columns, but, it only works if its the only line in the email. unfortunately as per my example below, its not the only text in the body. Example email. List of APPROVED tracksheets by Commercial Assistant For reference the following...
  14. W

    Outlook body to Excel Document

    Hi Diane Appreciate your help so far. The data required is not the only line in the email, it's always received as below. I'm not even fussed about when it gets to Excel that it splits it into columns, the whole line starting with P130 can go into one column on one row...
  15. W

    Outlook body to Excel Document

    Hi Diane, basically say I had an email which contained the following text amongst other text I would need to pick out the relevant data. I would like to get the script to find the line with P130600439 100356 ACTI149 202 0 on it and split them into columns adding to the last row each...
Top