Hyperlink VBA

Status
Not open for further replies.
J

jdl_131

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi, I frequently write emails with a few different hyperlinks in them. I am sort of like tech support for my company and for example if a customer asks what tire pressure he should have I would give a link to www.tirepressure.com or if they ask which oil to use I would give a link to www.oil.com. Those websites are just examples, I don't work in the car industry. Now for what I am looking to accomplish:




  1. Ideally I would like to have auto-correct replace a word that I type with a correctly formatted hyperlink (blue text w/underline) to a specified website. I have tried to do this but all I can get it to do is replace the word with the unformatted web address and since most of my links are quite lengthy (~75-100 characters) this doesn't look good in an email and the links aren't clickable anyway. So basically I want to type "Google" and then have word replace it with "Google"...not "www.google.com".

  2. Alternatively I would like to have a macro that I can run by hot-key to insert the formatted link for me.






I have tried all kinds of code I've found on the WWW but I can't get it to work. Your help would be very much appreciated!




Thank you
 
Autoformat can handle up to 248 characters and should work for this - create the text block, select it, then go to autocorrect and choose the 'formatted text' option. (For longer text, use autotext or quick parts) Macro is also possible, but I don't think i have any samples - will put one together though.

autocorrect.png
 
Status
Not open for further replies.
< Outlook 2010 change birthdays from all day to specific time | Export Outlook Calendar >
Similar threads
Thread starter Title Forum Replies Date
M VBA Rule for removing all body but hyperlink then forwarding Outlook VBA and Custom Forms 9
S email body without "HYPERLINK" ( vba ) Using Outlook 6
K Add Hyperlink in Email Body by VBA Outlook VBA and Custom Forms 1
C No Hyperlink when Sharing an article from the Web Using Outlook 3
V Embedding hyperlink into Word document Using Outlook 2
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
L Ignore hyperlink from being flagged as false pattern Outlook VBA and Custom Forms 3
D Custom form with html hyperlink Outlook VBA and Custom Forms 7
N open the hyperlink in Outlook directly instead of browser Using Outlook 1
M How to view the URL for a hyperlink? Using Outlook 1
A Add Hyperlink to Task Outlook VBA and Custom Forms 11
Q Why can't I copy image with embedded hyperlink from email to Word Using Outlook 0
P URL Hyperlink not working correctly in Outlook 2003 Using Outlook 10
A Create Macro for hyperlink(email) in message body Outlook VBA and Custom Forms 9
Diane Poremsky Disable the Unsafe Hyperlink Warning when Opening Attachments Using Outlook 0
V Using custom field data in mail body + mailto hyperlink Outlook VBA and Custom Forms 7
C Hyperlink to an Outlook search Using Outlook 1
makinmyway Recent Files Not Updating when Using Insert Hyperlink in Outlook 2013 Using Outlook 0
E Create a URL hyperlink in an Outlook custom form? Outlook VBA and Custom Forms 2
J Macro generating email using default signature and hyperlink Outlook VBA and Custom Forms 5
Witzker HYPERLINK "mailto:test@test.com" in form body Using Outlook 21
Hudas Hyperlink Saved Outlook Email to MS Access Table Using Outlook 4
D Particular Facebook "Hyperlink" Issue In Office 2010 Outlook (32 bit) Using Outlook 5
M How to create a hyperlink to to an organizational form Using Outlook 5
P Can't add a custom hyperlink to toolbar in OL 2010 Using Outlook 1
T Desable Hyperlink on email Using Outlook 3
O Hyperlink formatting lost after replacement in outlook Using Outlook 5
O Hyperlink formatting lost after replacement in outlook Using Outlook 0
G Hyperlink Using Outlook 1
T Hyperlink Issue Using Outlook 2
P Hyperlink to Access record/Form Outlook VBA and Custom Forms 2
M auto click hyperlink?! Outlook VBA and Custom Forms 1
M Auto click a hyperlink Outlook VBA and Custom Forms 2
R Inserting a hyperlink in the bod of an outlook appt. Outlook VBA and Custom Forms 13
C VBA in "New Outlook?" Using Outlook 0
efire9207 VBA Outlook Contacts Outlook VBA and Custom Forms 6
B Requesting VBA code to make Outlook prompt for confirmation when deleting a task? Outlook VBA and Custom Forms 4
M Outlook 365 VBA Auto-Forward Only the first of Duplicate Emails Outlook VBA and Custom Forms 2
N VBA Code Not Working correctly Outlook VBA and Custom Forms 1
L VBA to Triage Incoming Email Outlook VBA and Custom Forms 0
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 4
H using VBA to edit subject line Outlook VBA and Custom Forms 0
G Get current open draft message body from VBA Outlook VBA and Custom Forms 1
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
R Outlook 2019 VBA to List Meetings in Rooms Outlook VBA and Custom Forms 0
geoffnoakes Counting and/or listing fired reminders via VBA Using Outlook 1

Similar threads

Back
Top