VBA or MACRO help!

Some discussions just don't fit into a well defined box. Use this forum to discuss general topics and issues revolving around the Church and the technology offerings we use and share.
Post Reply
fletcher.carpenter
New Member
Posts: 12
Joined: Tue Jun 01, 2010 9:52 pm
Location: United States, Mesa, AZ

VBA or MACRO help!

#1

Post by fletcher.carpenter »

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.
Top
User avatar
Mikerowaved
Community Moderators
Posts: 4508
Joined: Sun Dec 23, 2007 12:56 am
Location: Layton, UT

#2

Post by Mikerowaved »

You might get a better answer posing your question to a forum that deals exclusively in VBA coding, such as THIS one.
So we can better help you, please edit your Profile to include your general location.
Top
jonesrk
Church Employee
Church Employee
Posts: 2076
Joined: Tue Jun 30, 2009 8:12 am
Location: South Jordan, UT, USA

#3

Post by jonesrk »

You can just use the SUBSTITUTE function eg SUBSTITUTE(a1, "-", "") if a1 had the phone number
Top
User avatar
marianomarini
Senior Member
Posts: 619
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy

#4

Post by marianomarini »

In Italian is: CONCATENA(SOSTITUISCI(A1;"-";"");"@vtext.com")
In English (I suppose): LINK(SUBSTITUTE(A1;"-";"");"@vtext.com")
This work with OpenOffice.org
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).
Top
lajackson
Community Moderators
Posts: 10601
Joined: Mon Mar 17, 2008 10:27 pm
Location: US

#5

Post by lajackson »

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.
Top
User avatar
marianomarini
Senior Member
Posts: 619
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy

#6

Post by marianomarini »

Thank lajackson. (So there is a word less longer in Italian than English!!)
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).
Top
Post Reply

Return to “General Discussions”