When you click on a hyperlink in an Outlook email, the link will be opened in your default internet browser. But actually you can also use the method introduced in this article to open hyperlink directly in Outlook.
You must have known that when you click on a hyperlink in an Outlook email, the webpage of the link will open by your default Internet Browser. However, there are many users who would like to directly open the hyperlink within Outlook. In the earlier versions of Outlook, there was a visible and obvious web tool. But now, this feature is hidden. Even so, actually, Outlook can still work as a web browser. You can apply the following method which is using Outlook VBA to achieve it in quick time.
Open Hyperlink in Outlook Directly instead of New Browser Window
- In the first place, launch your Outlook application.
- Then press “Alt + F11” key buttons.
- Subsequently, you will get into Outlook VBA editor window successfully.
- Next copy and paste the following VBA codes into a not-in-use module.
Public Sub OpenHyperlinkswithinOutlook()
Dim objMail As Outlook.MailItem
Dim objWordDocument As Word.Document
Dim objHyperlinks As Word.Hyperlinks
Dim i As Long
Dim objHyperlink As Word.Hyperlink
Dim strHyperlinkList As String
Dim strNumber As String
Dim strURL As String
Dim objExplorer As Explorer
Dim objWebBrowser As Object
Dim nAlert As Integer
On Error Resume Next
Select Case TypeName(Outlook.Application.ActiveWindow)
Case "Inspector"
Set objMail = ActiveInspector.CurrentItem
Case "Explorer"
Set objMail = ActiveExplorer.Selection.Item(1)
End Select
Set objWordDocument = objMail.GetInspector.WordEditor
Set objHyperlinks = objWordDocument.Hyperlinks
If objHyperlinks.Count < 1 Then
nAlert = MsgBox("There is no hyperlink in this email!", vbExclamation)
'Get the URL of the only hyperlink
ElseIf objHyperlinks.Count = 1 Then
Set objHyperlink = objWordDocument.Hyperlinks.Item(1)
strURL = objHyperlink.Address
'Select which hyperlink to open
ElseIf objHyperlinks.Count > 1 Then
For i = 1 To objHyperlinks.Count
strHyperlinkList = strHyperlinkList & i & ": " & objHyperlinks.Item(i).Address & vbCrLf
Next i
For i = 1 To objHyperlinks.Count
strNumber = InputBox("You have " & objHyperlinks.Count & " hyperlinks in this email as follows. " & vbCrLf & vbCrLf & "Please enter the number to select which one to be opened within your Outlook (format: 1)." & vbCrLf & vbCrLf & strHyperlinkList, "Select Hyperlink")
Set objHyperlink = objWordDocument.Hyperlinks.Item(strNumber)
strURL = objHyperlink.Address
Exit For
Next i
End If
'Open the selected hyperlink
Set objExplorer = Application.ActiveExplorer
Set objWebBrowser = objExplorer.CommandBars.FindControl(, 1740)
objWebBrowser.Text = strURL
objWebBrowser.Execute
End Sub
- After that, add the new macro to Quick Access Toolbar or ribbon as usual.
- Later change your Outlook macro security level to low.
- Finally you can have a try. Firstly, select or open an email and then hit the macro button. Here are 3 cases depending on the total count of hyperlinks in the email.
- If there is no hyperlink in the email, you will get a warning, shown as the following screenshot:
- If there is only one hyperlink in the email, the link will be opened at once, like the image below:
- If there are several hyperlinks in the email, you will be required to select a hyperlink, like the picture below. After you entering the number of the selected hyperlink, the according webpage will be opened at once.
Never Fear PST Troubles
Many users will get panic as soon as they encounter unexpected PST corruption. It is because that they haven’t made sufficient precautions, such as the up-to-date PST data backups and an experienced repair tool like DataNumen Outlook Repair. In fact, as long as you keep well-prepared, you won’t need to fear any PST issues.
Author Introduction:
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf corruption and outlook repair software products. For more information visit www.datanumen.com
However, as soon as you obtain past the preliminary intro stage, they will certainly open more and come to be more certain around you. Open and produce multiple files in new tabs of the exact same window, instead than in brand-new home windows. In the long-term, the European market for days is expected to reveal steady development. I am US-based and obtaining a report that gives me dates in European text style. When we use Russian dating sites to meet European females, we want a risk-free and effective date and discover our life partner efficiently and properly. 2. Ukrainian females often find that international men have top qualities that they value highly in a partner. It shows that you value the female’s time and are really devoted to the partnership. DATE(VALUE(RIGHT(C2,4)), VALUE(MID(C2,4,2)), VALUE(LEFT(C2,2))), drag fill take care of down to apply this formula to the cells. If the dates you got are formatted as European or US dates, you can apply Format Cells operate to promptly take care of the conversion between European and US countries. 3. Click OK. Now the European days have actually been transformed to US days. How to quickly convert date layout in between European and US in Excel?
Note: If you intend to convert day layout of US to European’s, you can pick English (UK) from the Locale (location) fall checklist, and select one sort of date from the above list in Format Cells dialog. 2. Then in the Format Cells dialog, under Number tab, and click Date form the Category listing, and select English(United States) from the Locale (area) fall listing, and go to the Type listing to select one day forma as you require. 1. Select the dates you desire [url=htttps://www.linkedin.com/in/charmingdate]charmingdate review[/url] to transform, and right click to select Format Cells from the context menu. You can apply a formula to convert the dates from European to United States if the days in the sheet you have actually gotten are formatted as texts. In the formula, C2 is the date you wish to transform from European texted date to US day. In this situation, exactly how can you quickly transform the date style in between European nations and US in Excel? 4. Which trends provide opportunities on the European dates market? 2. What makes Europe an intriguing market for dates? 50%) are seldom offered on the European market. 3. Which European nations supply most chances for dates? For instance, the European counties record dates in the date layout dd/mm/yyyy, while US record dates in the date format mm/dd/yyyy.
Hotel team on her European scenic tour are stated to be under orders to eliminate alcohol from her space. You can inform your close friends or ask the aid from the staff of dating sites. In some cases, our instincts inform something right. I have actually spent a bunch of time attempting to automate this yet I can’t find a great way to do it. The important things is that I am constantly updating this record with net-new information so I can not utilize the Text-to-Columns option that converts the day without a bunch of hands-on actions. You can have online conversation with Russian females or make use of various other ways to obtain a great understanding before informing your vital information. Don’t provide your individual information when filling in your account and providing your self-introduction if you can not pay for a paid dating website and use a free one. Your online dating account is your impression and can make a huge difference in exactly how successful you are in meeting Ukrainian females. Did you just join a good website and develop your online dating account?
Especially pay hearken to the odd actions and words from the girl you are dating. On one hand, by doing this your concerns concerning the lady are cleaned up. It is an ideal way to develop a perception on the woman. Be person and allow your connection create in an all-natural method. On the other hand, your relationship actions additionally. So you must share your very own recognition for family members worths and illustrate your need for a purposeful, long-lasting partnership. With this recognizing a few of you can make the choice regarding whether they intend to advance the connection with ladies. It is of utmost relevance to research the websites that you plan to utilize to discover beautiful Ukrainian ladies. Use the website solutions to keep in get in touch with and very first spend a long time getting familiarized with charming Russian ladies online. To conclude, making use of a Ukrainian marriage company will offer you security and ease, and it uses all the solutions you need to satisfy a solitary Ukrainian woman face to face. So you can make miraculous of services on dating platforms and use video conversation solution to satisfy and chat her in person on the net.