E-Mail Worksheet Only (XP)

Topic

New Reply

I was just wondering if it is possible to e-mail one worksheet and not the ten or so worksheets. I have been cutting and pasting or hiding sheets but was wondering if there is an easier way.

thanks

Reply | Quote

Replies

See http://www.rondebruin.nl/sendmail.htm%5B/url%5D (thanks to sdckapr for mentioning this useful site.)

Reply | Quote

Thanks Hans this site is great.

Lance

Reply | Quote

Thanks Hans this site is great.

Lance

Reply | Quote

If you are asking how to do this without using VBA Code, then:

• Make sure that your workbook is not maximised in Excel.
• Put your cursor inside the name area at the bottom of the target worksheet.
• Pressing down Ctrl AND your left mouse button at the same time, drag towards a blank area outside the workbook – but inside Excel. (You should see a tiny worksheet with a plus sign in it.)
• Release Ctrl and the mouse.
• Choose File|Send to|Mail Recipient (as attachment)[/list]HTH

Reply | Quote

This works great.

thanks

Reply | Quote

This works great.

thanks

Reply | Quote

If you are asking how to do this without using VBA Code, then:

• Make sure that your workbook is not maximised in Excel.
• Put your cursor inside the name area at the bottom of the target worksheet.
• Pressing down Ctrl AND your left mouse button at the same time, drag towards a blank area outside the workbook – but inside Excel. (You should see a tiny worksheet with a plus sign in it.)
• Release Ctrl and the mouse.
• Choose File|Send to|Mail Recipient (as attachment)[/list]HTH

Reply | Quote