I have an Excel Column “Name” that contains a first name and a last name. I need to create e-mail IDs from the names in the format FirstName.LastName@xyz.com.
I am assigning the following variables
SplitName = row.Item(0).ToString.Split(" "c)
FirstName= SplitName(0)
LastName= SplitName(1)
However, I am getting the “Index was outside…” exception.
How do I resolve this ?
Please provide your ideas.
Thanks!