The ongoing saga of the exit/movement survey continues. My workmate that
collects the data from this intranet survey, that once completed is sent by
email via a submit button, would like the date the survey was sent to appear
on the completed survey.
After she has received the form she then stores them in a folder so she can
work on them later. When she eventually retrieves them she would like to be
able to see what date they were sent. I would like to be able to put a macro
or something in a cell on the sheet so the sender doesn't have to do it.
Obviously I don't want the date to automatically update when she opens the
sheet either. Thanks in advance again.

Cheers
Lynda