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

Dialogs(xlDialogSendMail).Show - how to delete attachment? 2
excel programming 4
open outlook and add email address 5
Need to fix macro to send workbook via email 1
Add pdf attachment to new mail 7
Application.Dialogs(xlDialogSendMail).Show 1
Sending e-mails from specific email address 2
Remove code from a worksheet before emailing 12

Top