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: 137
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



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 11:13 PM.


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