How to send an email from Word using VBA without a routing slip

C

charlie6067

I've seen Doug Robbin's excellent instructions on this subject when a
user has Outlook mail program. My company uses Lotus Notes. If I try
to attach a routing slip in Word, it errors out as the mail program
lacks features needed by Word.

I know Word has a Send for Review and Send as an Attachment features
but I also want to populate the To and Subject email fields when it
opens in Lotus Notes. Strange, but Word has a hyperlink feature that
allows pre-populating the To and Subject email fields but doesn't
provide a method to attach the document.

This code works great except it won't let me specify the fixed To and
Subject fields. Any ideas or code will be welcome. Have tried a few
ideas from VBA Help but nothing worked. I use Word 2003 and some users
will have Word 97.

Sub SendAttachment()
'Attaches document to a blank email in Lotus Notes. Action opens Notes
if closed.

Options.SendMailAttach = True
ActiveDocument.SendMailer

End Sub

Thank you,
Charlie charlie6067
 

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

Top