Forum Discussion
Solved
VBA to create new CSV file from the existing one with modified email address
Hello, I need a VBA which will automatically create a new CSV file from the old one (attached) based on this criteria: Update column email with domain abc.com Email format: first letter from nam...
Change
sMail = wsh.Range("B" & r).Value & Left(wsh.Range("C" & r).Value, 1) & _ Split(wsh.Range("C" & r).Value)(1) & "@abc.com"to
sMail = Left(wsh.Range("C" & r).Value, 1) & Split(wsh.Range("C" & r).Value)(1) & _ wsh.Range("B" & r).Value & "@abc.com"
Thank you, Hans!
The problem with this code is that it displays the department_id before the name. I need it to be shown before the @ symbol
Change
sMail = wsh.Range("B" & r).Value & Left(wsh.Range("C" & r).Value, 1) & _
Split(wsh.Range("C" & r).Value)(1) & "@abc.com"to
sMail = Left(wsh.Range("C" & r).Value, 1) & Split(wsh.Range("C" & r).Value)(1) & _
wsh.Range("B" & r).Value & "@abc.com"
- Awesome! Many Thanks!