Looking for macro to send page as email.

[Palo]

I'm developing an interactive document and would like to include an evaluation and registration page that the end-user can send back to me by double-clicking the macro field.

"Record Macro" will track my keystrokes only as far as calling up the email client. It won't repeat my email address in the client itself.

Any suggestions?

Bill Palladino (PALO)

 

[JVFriederick]

You didn't mention what software is being used. For Excel :

'Select and Email each file
MailName = Selection.Range("A1&quot ' get who from current cursor cell
MailFile = Selection.Range("B1&quot ' get filename from current cell + 1 column to right
Windows(MailFile).Activate ' Activate the file to Email
ActiveWorkbook.SendMail Recipients:=MailName, Subject:="Here ya go . . ." ' Send it

 

[Palo]

Sorry about that...

Using MS WORD 2000.

Will the same macro work?

Thanks,

Palo

 

[JVFriederick]

Not sure. Never tried in Word before.