Dear all,
I have a simple requirement.
Suppose i have few mail ID's as below,
aaaa.bbbbbb@xx.com
ccccccc.dd@xx.com
eeeeeeeeeeee.f@xx.com
I want the vba code and extract firstname and last name from the these mail ID's
Note: From beginning till special character "." are my first names.
And from "." till special character "@" are my second names.
Please provide me the code.
Thanks
Madvesh
I have a simple requirement.
Suppose i have few mail ID's as below,
aaaa.bbbbbb@xx.com
ccccccc.dd@xx.com
eeeeeeeeeeee.f@xx.com
I want the vba code and extract firstname and last name from the these mail ID's
Note: From beginning till special character "." are my first names.
And from "." till special character "@" are my second names.
Please provide me the code.
Thanks
Madvesh