it might be an easy solution but I am trying few hours to pull some numbers from outlook to excel via macro. Email has line with "Attendance" and i need the figure afterwards. Figure could be from 1 to 10,000.

((Attendance\w*)\s*(\w*)\s*(\w*)\s*(\w*)\s*([\d-\.]*))

it works for the numbers without comma but shows only the first number before comma for the numbers with comma.

Has anyone got solution for that pleas?

CodePudding user response：

Try this:

Attendance.*?([0-9,]{1,6})