Hi

I am currently producing a rather large spreadsheet on a daily basis, which
is automatically saved to sharepoint. This is great, but I would also like
to generate an email which sends only a link to the file in the subject field
of the email, with perhaps a message in the body o fthe email stating that
today's file is available.

I currently use Application.Dialogs(xlDialogSendMail).Show, which is also
good, but this obviously always inserts the spreadsheet as an attachment and
is therefore not providing what I would like.

Can anyone please advise the best solution.

Thanks in advance

Richard

Hi,

Take a look at Ron's excellent site ...
http://www.rondebruin.nl/sendmail.htm

Cheers