ASU wrote:
I've got a form which gets E-mailed once a week. At the moment the
recipient E-mail address is written in a code and if I wish to change
the address I have to enter the code and change it that way. Is there
a way which I can do that using a cell on the actual form.

Supposing that the address is held in Sheet1!A1 then swap the hard coded
address for [Sheet1!A1].Value