Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2020, 01:32 AM
cjamps cjamps is offline Autotext Macro Windows 8 Autotext Macro Office 2010 32bit
Novice
Autotext Macro
 
Join Date: Mar 2017
Posts: 16
cjamps is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-04-2020, 09:15 PM
AlanCantor AlanCantor is offline Autotext Macro Windows 10 Autotext Macro Office 2019
Competent Performer
 
Join Date: Nov 2020
Posts: 134
AlanCantor is on a distinguished road
Default

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!
Reply With Quote
Reply

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
Autotext Macro Using autotext automatically Thedane Word 5 11-19-2014 09:00 PM
Autotext Macro Autotext jafrapatty Word 2 05-09-2014 04:30 AM
Autotext Macro Inserted AutoText table incorrectly formatted - unless macro paused! Smallweed Word VBA 4 01-16-2014 03:15 PM
Autotext Macro Autotext within Fields gotmatt Word 2 06-29-2011 06:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft