Email and string space removal

[gordsky]

Hi, I currently have a macro to send emails using vba and our internal email to sms system

It works find except when the recipe string finds a space.

I currently have
dim recip as string
Ctr = 2
Recip = cells(ctr, 6) & "@sms.htkmessaging.com"

The info at (ctr, 6) sometimes contains a phone number which due to the way it is imported sometimes has a space in it eg 01234 567 677

The system fails if a space is present so is it possible to remove the spaces from within the code.

I know I could remove them prior to running the macro but I want to be able to do it all in one action

Many thank

 

[mancubus]

please use 'code tags' when posting code here.

perhaps

Recip = Replace(Cells(ctr, 6), " ", "") & "@sms.htkmessaging.com"

 

[gordsky]

Works perfect thank you