Email using Outlook

R

Richard

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Outlook linking to non default browser Edge 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Synchronization problems while moving folders to new email 1
excel programming 4
Outlook 365 overriding formatting choices 0
Dialogs(xlDialogSendMail).Show - how to delete attachment? 2
open outlook and add email address 5

Top