Email textbox contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thronz - 26 Jul 2005 03:27 GMT

I have a document that I've added VBA to. What I can't seem to figure out is
how to forwardthe contents of just one textbox on the userform to a mailing
list without sending the entire document. Is it possible to email textbox
contents themselves?
Thanking you in advance.

Reply to this Message

Doug Robbins - 26 Jul 2005 05:09 GMT

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Forget all the stuff about the attachments. what you need to do is set the
.Body to the contents of the text box.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a document that I've added VBA to. What I can't seem to figure out
>is
[quoted text clipped - 3 lines]
> contents themselves?
> Thanking you in advance.

Reply to this Message

Thronz - 30 Aug 2005 23:29 GMT

I found another way to send the text from the textbox on the userform as the
body of the email:

ActiveDocument.HasRoutingSlip = True
With ActiveDocument.RoutingSlip
.Subject = "Building Defects"
.Message = TextBoxBuildingDefects.Value (the text to send)
.AddRecipient Recipient:="recipient"
End With
ActiveDocument.Route

This work except for the fact that it also includes the active document as
an attachment. How can I stop the attachment?

> See the article "Mail Merge to E-mail with Attachments" at
>
[quoted text clipped - 10 lines]
> > contents themselves?
> > Thanking you in advance.

Reply to this Message

Doug Robbins - 31 Aug 2005 05:17 GMT

Use a modification of the other method in that article.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I found another way to send the text from the textbox on the userform as
>the
[quoted text clipped - 28 lines]
>> > contents themselves?
>> > Thanking you in advance.

Reply to this Message