I just don't want the date to change if my boss emails it to his boss or
whatever.
Would like it to be automatic but if it's realy difficult or impossible I'll
manage.

"Ron de Bruin" wrote:

Then it is not possible.

You can use code to automatic insert the last saved date into the file.

Is that a option



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
I attace it to a mailing in outlook. my documents folder open and the mail
and just drag and drop.

Kevin

"Ron de Bruin" wrote:

How do you mail it
FileSend To or with a macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin