However this doesn't do the trick as in calling the script itself - it simply emails me with the URL

Of course it does. Look at what your script does - it only prints a text string.
You want it to masquerade as a browser - use LWP::Simple (there are many, many other choices as well).

#!/usr/bin/perl

use warnings;
use strict;
use LWP::Simple;
my $target = "http://www.mysite.com/cgi-bin/cd.pl";

$content = get($target);   #Actually send the request to the webserver
        die "Couldn't get $target!" unless defined $content;
[download]