Recent content by wmiles

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

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

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

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

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

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.

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

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

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

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

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.

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

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

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

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