Tracking number as hyperlink in report

[Smoothcat74]

Hi all,

I've been searching the forums and couldn't quite find help on this issue, so I'm starting this thread. My apologies if it has already been addressed elsewhere. Here's the deal:

I have database that tracks shipments to our customers, then sends out email notifications to them to notify them that their order has shipped. They receive a .pdf document with all the details of their FedEx shipment, including tracking number.

What I would like to do is have the tracking number be a hyperlink to the FedEx tracking website so that our customers can quickly check the status of their delivery. How would I use VBA to input the hyperlink into the report field and attach the tracking number to the end of the URL query.

Here's the FedEx URL minus the tracking number info that needs to be applied to the very end of the string:

http://www.fedex.com/Tracking?ascen...age=english&tracknumbers=TRACKING_NUMBER_HERE

Any help will be greatly appreciated!

 

[Smoothcat74]

Ok, I think I have a good idea of how I could accomplish this. Let me narrow my question down to the following:

Is it possible to export a PDF from Access that has active hyperlinks in the document?