Send Excel form VIA Email

[Sam]

I have an Excel form that has a submit button and this button should
open up a MS Outlook email attach the form and past the value from
cell R13 in to the subject. Is there code that will do this? If, so
what would it be? I tried the little I know but could not get it to
work.

Thanks
Sam

 

[Ron de Bruin]

Hi Sam

See
http://www.rondebruin.nl/mail/folder2/mail3.htm

Read the tips for changing the macro
http://www.rondebruin.nl/mail/tips2.htm

 

[Ron de Bruin]

Oops

This is a example for one sheet
http://www.rondebruin.nl/mail/folder1/mail2.htm

 

[Sam]

Oops

This is a example for one sheethttp://www.rondebruin.nl/mail/folder1/mail2.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






- Show quoted text -

This worked great. Is there a way to check to see if certian
conditions are met. For example do not run unless Cell B5 & J5 are
populated>

Thanks for your help!!!!!

 

[Ron de Bruin]

You can test it like this

Sub test()
If WorksheetFunction.CountA(Range("B5, J5")) = 2 Then
'Run your mail code
Else
MsgBox "Please fill in B5 and J5"
End If
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Oops

This is a example for one sheethttp://www.rondebruin.nl/mail/folder1/mail2.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






- Show quoted text -

This worked great. Is there a way to check to see if certian
conditions are met. For example do not run unless Cell B5 & J5 are
populated>

Thanks for your help!!!!!