Hyperlink VBA

Status
Not open for further replies.

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
 

Forum Admin

Senior Member
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.
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
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
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
TedSch Small vba to kill political email Outlook VBA and Custom Forms 3
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
Z VBA Forward vs manual forward Outlook VBA and Custom Forms 2
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Any way to force sort by/group by on search results with VBA? Outlook VBA and Custom Forms 1
E Default shape via VBA Outlook VBA and Custom Forms 4
A Change settings Send/receive VBA Outlook VBA and Custom Forms 0
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
D VBA code to select a signature from the signatures list Outlook VBA and Custom Forms 3
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1

Similar threads

Top