Anyone got any ideas on how to generate a unique reference in an email created using Renewal Reminder?

We are wanting to send out an email as an Invoice with the module and one of the requirements is a unique reference number.

TIA

Antony

HI, you could create a hidden field and have it set to a uniqeidentifier default value:

select (newid() +' ' +$(UserID)) as defaultvalue

Include that hidden field token in your Renewal Reminder email. See if this will work for you. -- David