Hi there,

Can anyone help be with VB Commands for 'Command buttons' please?

What i want to do is send a information from a particular row on a
spreadsheet as an attachment within a new email window?

Do i have to highlight the row itself and then click on the 'Send Email'
button? (ive created the actual button itself, its just the code i need to
know).

If anyone could write the actual code, and then i can copy and paste the
command into the VB page that would be great! I dont want to send the whole
active worksheet, just a particular row/line on it...

Thanks everyone...

GG

See Ron DeBruin's site on email:
http://www.rondebruin.nl/sendmail.htm

Mike F
"genuinegal via OfficeKB.com" <u14743@uwe wrote in message
news:55a01c4a4eef7@uwe...
Hi there,

Can anyone help be with VB Commands for 'Command buttons' please?

What i want to do is send a information from a particular row on a
spreadsheet as an attachment within a new email window?

Do i have to highlight the row itself and then click on the 'Send Email'
button? (ive created the actual button itself, its just the code i need to
know).

If anyone could write the actual code, and then i can copy and paste the
command into the VB page that would be great! I dont want to send the
whole
active worksheet, just a particular row/line on it...

Thanks everyone...

GG