Writer insert UserData field email as hyperlink


I’m using writer and have set the field email via tools->options->LibreOffice->UserData->email. I wish to include this field in a footer as a hyperlink both in the document and in the footer.

LO autodetects the email if I type it but adding it as a field seems to stop the conversion to a mailto: hyperlink.

Is there a way to accomplish this? Any suggestions are appreciated. Thanks,