VBA or MACRO help!

fletcher.carpenter · Post by **fletcher.carpenter** » Fri Jan 21, 2011 6:48 pm

I don't know a lot about programing or code.
I need to write a Macro or use some code to take cell phone numbers from an excel spreadsheet and eliminate the dashes
eg 480-123-4567 would become 4801234567
Then I need to take all of those numbers and attach @tmomail.net or @vtext.com to the end of it, then take all of those phone numbers turned email addresses and send a message through windows mail.
I have heard of this being done, but do not have the code.

Post by **Mikerowaved** » Fri Jan 21, 2011 7:17 pm

You might get a better answer posing your question to a forum that deals exclusively in VBA coding, such as THIS one.

jonesrk · Post by **jonesrk** » Sat Jan 22, 2011 12:17 am

You can just use the SUBSTITUTE function eg SUBSTITUTE(a1, "-", "") if a1 had the phone number

marianomarini · Post by **marianomarini** » Mon Jan 24, 2011 1:29 pm

In Italian is: CONCATENA(SOSTITUISCI(A1;"-";"");"@vtext.com")
In English (I suppose): LINK(SUBSTITUTE(A1;"-";"");"@vtext.com")
This work with OpenOffice.org

Post by **lajackson** » Tue Jan 25, 2011 2:09 pm

marianomarini wrote:In Italian is: CONCATENA(SOSTITUISCI(A1;"-";"");"@vtext.com")
In English (I suppose): LINK(SUBSTITUTE(A1;"-";"");"@vtext.com")
This work with OpenOffice.org

CONCATENATE instead of LINK will do it.

marianomarini · Post by **marianomarini** » Wed Jan 26, 2011 12:32 pm

Thank lajackson. (So there is a word less longer in Italian than English!!)