When using the "mailto" function in a macro, it allows me enter the
receipient and subject, but I'm not sure of the coding used to enter text
into the body of the email, in short I need to email the link for the
location of the spreadsheet for the user to click on in the email so it
automatically opens.

cheers,
Mike