How to set recipient using SendMail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Bell - 22 Jul 2003 15:11 GMT

I am trying to add a command button to a document that
will allow users, once they have completed the document to
automatically send an email to a given email address.

This attaches the doument fine but I can't see any way of
automatically setting Subject, Message and most
importantly, Recipient.

I have had a look at a MAPI download that allows me to do
this but this method doesn't seem to allow you to attach a
document and you receive a message each time warning
about the possibility of viruses. (I know there is a
download to prevent this method but this solution wouldn't
be acceptable)

Reply to this Message

Doug Robbins - Word MVP - 23 Jul 2003 11:24 GMT

Hi Peter,

See the article "How to send an email from Word using VBA" at:

http://www.mvps.org/word/FAQs/InterDev/SendMail.htm

To get around the virus warning problem, download the "Express ClickYes"
utility that is available as a free download from
http://www.express-soft.com/mailmate/clickyes.html

Express ClickYes is a tiny program that sits in the taskbar and clicks the
Yes button on behalf of you, when Outlook's Security Guard opens prompt
dialog saying that a program is trying to send an email with Outlook or
access its address book. You can suspend/resume it by double-clicking its
taskbar icon. Developers can automate its behaviour by sending special
messages.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am trying to add a command button to a document that
> will allow users, once they have completed the document to
[quoted text clipped - 10 lines]
> download to prevent this method but this solution wouldn't
> be acceptable)

Reply to this Message