Help!

Sending Current Word Document as Email from a button or link

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Mail RSS
Next:  Missing Disk  
Author Message
rprewitt
External


Since: Jan 20, 2009
Posts: 1



PostPosted: Tue Jan 20, 2009 2:36 pm    Post subject: Sending Current Word Document as Email from a button or link
Archived from groups: microsoft>public>word>mail (more info?)

--------------------------------------------------------------------------------
I have a shared Word document that is being used as a form. When a user
finishes filling out the fields on the form, I want them to click a link or
push a button that sends the document as an attachemnt to a specific email.

Eg: User fills out document, clicks on button or link, the current document
is attached to a new Outlook email and has the To: field already populated
with name DeleteThis @abc.com

I did find some simple code that will take the current document and attach
it to a new email.


Code:
--------------------------------------------------------------------------------

Sub CommandClick()

Application.Options.SendMailAttach = True 'Or False
ActiveDocument.SendMail

End Sub
--------------------------------------------------------------------------------

This is great and all, but I need the To: field to be populated with a
specific email address.

Any help would be appreciated.

Thanks
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2665



PostPosted: Tue Jan 20, 2009 11:10 pm    Post subject: Re: Sending Current Word Document as Email from a button or link [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Use the second method in the article "How to send an email from Word using
VBA" at:

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

--
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

"rprewitt" <rprewitt DeleteThis @discussions.microsoft.com> wrote in message
news:632CD655-C93E-455B-BE2B-961219B5CF6D@microsoft.com...
> --------------------------------------------------------------------------------
> I have a shared Word document that is being used as a form. When a user
> finishes filling out the fields on the form, I want them to click a link
> or
> push a button that sends the document as an attachemnt to a specific
> email.
>
> Eg: User fills out document, clicks on button or link, the current
> document
> is attached to a new Outlook email and has the To: field already populated
> with name DeleteThis @abc.com
>
> I did find some simple code that will take the current document and attach
> it to a new email.
>
>
> Code:
> --------------------------------------------------------------------------------
>
> Sub CommandClick()
>
> Application.Options.SendMailAttach = True 'Or False
> ActiveDocument.SendMail
>
> End Sub
> --------------------------------------------------------------------------------
>
> This is great and all, but I need the To: field to be populated with a
> specific email address.
>
> Any help would be appreciated.
>
> Thanks
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Mail All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum