CODEWITHSUNDEEP
htmlvbavariables
Greg
Greg

Reputation: 63

Outlook VBA variable into HTML Body

I created an Macro in MS Outlook for an email. The user inputs an answer to a question which results in a variable storing that data as a string. An email is then generated in HTML with a hyperlink containing that variable. I can't seem to figure out how to concatenate the variable "strTrackingNumber" into the complete hyperlink. Any suggestions?

Option Explicit
Sub TestFile

Dim strTrackingNumber as String
strTrackingNumber = InputBox("Please input the Tracking Number")
Set objMsg = Application.CreateItem(olMailItem)

 With objMsg
  .To = "[email protected]"
  .CC = ""
  .BCC = ""
  .Subject = "Forecast"
  .Categories = ""
  .BodyFormat = olFormatHTML ' send HTML message
  .HTMLBody = "<style> body{color:black;font-family:Arial;font-size: 12pt;}" & _
"<HTML><body>Dear Member,<br><br>&emsp;The following document is ready for your review."<a href= 'http://www.bluewave.com/' & strTrackingNumber>Tracking & strTrackingNumber.</a></body>

.Display
End With
Set objMsg = Nothing
End Sub

Output link should look like this: http://www.bluewave.com/Tracking Number e.g. http://www.bluewave.com/RA-15-30922

Upvotes: 1

Views: 14166

Answers (1)

Tim Williams
Tim Williams

Reputation: 166885

.HTMLBody = "<style> body{color:black;font-family:Arial;font-size: 12pt;} </style>" & _
      "<HTML><body>Dear Member,<br><br>&emsp;" & _
      "The following document is ready for your review. " & _
     "<a href= 'http://www.bluewave.com/" & strTrackingNumber & "'>Tracking " & _
      strTrackingNumber & ".</a></body>"

Upvotes: 2

Related Questions