#1
|
|||
|
|||
Autotext Macro
I use email to text through SMS gateways. If someone tells me his carrier is verizon I write phonenumber@vzwpix.com as the email address
So I was just wondering if it's possible to create a macro to simplify the copying and pasting in the email address. if txt is verizon emailaddress1 = 9999999999@vzwpix.com emailaddress2 = 9999999999@vtext.com if txt is sprint emailaddress1 = 9999999999@pm.sprint.com emailaddress2 = 9999999999@messaging.sprintpcs.com if txt is att emailaddress1 = 9999999999@mms.att.net emailaddress2 = 9999999999@txt.att.net if txt is tmobile emailaddress1 =9999999999@tmomail.net Thanx |
#2
|
|||
|
|||
I use Macro Express Pro to automate procedures like that. It's probably do-able with Outlook VBA, but I find Macro Express easier to work with, especially when more than one application is in the mix.
A free, 30-day evaluation copy is available through Macro Express – Macros for your Windows Automation Needs. There are two versions: Macro Express and Macro Express Pro. The two are 90+% the same. Most users won't miss the extra bells-and-whistles of the Pro edition (e.g., supports for Boolean variables). The price difference between the two versions is modest. I imagine you could make the macro work in any number of ways: For example, perhaps you want to select the email address; or perhaps you want the macro to act on an entire email message or document. Use Macro Express to extract and modify the address via a series of text manipulation statements: If Address Contains "Sprint" then do this, etc. The macro might place the result in the Clipboard or export it into a text file. You might even be able to place the result in the Outlook address book. This sounds like a fun scripting project to me! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problems with Macro for inserting autotext when autotext name isn't followed by a space | amz1950 | Word VBA | 0 | 02-14-2018 10:20 AM |
Using autotext automatically | Thedane | Word | 5 | 11-19-2014 09:00 PM |
Autotext | jafrapatty | Word | 2 | 05-09-2014 04:30 AM |
Inserted AutoText table incorrectly formatted - unless macro paused! | Smallweed | Word VBA | 4 | 01-16-2014 03:15 PM |
Autotext within Fields | gotmatt | Word | 2 | 06-29-2011 06:05 PM |