Hiya,
Basically i have the message from an outlook mail body item that i need to search for a certain number within it.
The number can be anything from 2000 to 5000, but i want to search through the text until i come accross the first instance of the value and write it to a textbox. But im not to know what the number is as someone else will be feeding these numbers when they email me, so i need to scroll through the email pick up the number and then display some relevant data.
i.e. the no i might be searching for in an email is 4131. Need VBA code to search through the email then when it finds the 4 digit code it puts it in the textbox.
Can anyone help?
Stu
Basically i have the message from an outlook mail body item that i need to search for a certain number within it.
The number can be anything from 2000 to 5000, but i want to search through the text until i come accross the first instance of the value and write it to a textbox. But im not to know what the number is as someone else will be feeding these numbers when they email me, so i need to scroll through the email pick up the number and then display some relevant data.
i.e. the no i might be searching for in an email is 4131. Need VBA code to search through the email then when it finds the 4 digit code it puts it in the textbox.
Can anyone help?
Stu
