Email Word Survey doc

C

ClaudCar

I have a survey document that I want to have emailed to me as either an
attachment or in the body after it is completed. what do I add to the
hyperlink to tell it to send the whole doc as email?
 
C

ClaudCar

close but not quite. on the email link, I need it to pick the whole
document, as this is going to clients who won't be able (trust me) to
activate a macro.
____________________
Claudia
Totus Tuus
 
A

Anne Troy

I don't understand, ClaudCar. I understand that both macros will send the
document as an attachment. What do you mean "the whole document"? You may
need to put a command button on your document from which to run the macro,
if that's what you want.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 
C

ClaudCar

YES Anne - thank you - that is what I want - that the email to link runs the
macro.
 
C

ClaudCar

OK so if I want it to take ANY (OE, FF, Eudora) email program - what do I
do? and does the VBA code go into the button code? or is it separate from
the button itself. There is something that I am missing here. (obviously).
;-)
 
A

Anne Troy

No problem, Claud. So, do the MAPI one, but it won't work with Joe's
webmail, maybe, okay? Need an email client on the PC, like you asked for.
Go to View-Toolbars, and bring up the Control Toolbox. Draw a command button
on your document, probably at the end of it where you tell them it'll mail
to ya. Then double-click that button. Place the following code between the
sub/endsub for that button:
Dim Doc As Document

Application.ScreenUpdating = False
Set Doc = ActiveDocument
Doc.Save

SendIt "(e-mail address removed)", "A new Document", "Hi, read this:", Doc.FullName

Application.ScreenUpdating = True
Set Doc = Nothing

Copy all the rest of that code according to the instructions at the
knowledgebase entry. Here's the link, just to be sure:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=310
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 

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