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.
fletcher.carpenter
New Member
Posts: 12
Joined: Tue Jun 01, 2010 8:52 pm
Location: United States, Mesa, AZ

VBA or MACRO help!

Postby 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.

User avatar
Mikerowaved
Community Moderators
Posts: 3132
Joined: Sun Dec 23, 2007 12:56 am
Location: Layton, UT

Postby 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.
So we can better help you, please edit your Profile to include your general location.

jonesrk
Church Employee
Church Employee
Posts: 1455
Joined: Tue Jun 30, 2009 7:12 am
Location: Farmington, UT, USA

Postby jonesrk » Sat Jan 22, 2011 12:17 am

You can just use the SUBSTITUTE function eg SUBSTITUTE(a1, "-", "") if a1 had the phone number
Ryan Jones
CDOL Developer
Stake Technology Specialist - Software / Stake Assistant Clerk
Former Ward Clerk

User avatar
marianomarini
Senior Member
Posts: 594
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy
Contact:

Postby 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
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).

lajackson
Community Moderators
Posts: 6144
Joined: Mon Mar 17, 2008 9:27 pm
Location: US

Postby 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.

User avatar
marianomarini
Senior Member
Posts: 594
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy
Contact:

Postby marianomarini » Wed Jan 26, 2011 12:32 pm

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).


Return to “General Discussions”

Who is online

Users browsing this forum: No registered users and 1 guest