Hyperlink String to mail service

[moulin.rouge]

Hello,

I have a form where I am entering a mailing tracking number for a client order. Is it possible to have a code "on click" and use the number to track it on the website of the appropiate service provider?

 

[pbaldy]

Probably; look at FollowHyperlink in VBA help. Build a string appropriate to the providor, and then use FollowHyperlink to navigate to it.

 

[moulin.rouge]

I was able to add this to a commnad button and it works perfect. Now I just realized that I have other tracking numbers that are not for this vendor. Instead of adding a command button for each vendor is there an easier way to do this?



Private Sub Track_Click()
On Error Resume Next


Dim strURL As String
Dim strParam As String

strURL = "http://www.fedex.com/Tracking?action=track&language=english&ascend_header=1&cntry_code=us&initial=x&mps=y&tracknumbers="
strParam = Me!txtSearchText

strURL = strURL & strParam
Application.FollowHyperlink strURL


End Sub

 

[pbaldy]

Sure, but you would need some way of differentiating them, and obviously code to build the string appropriate to each.