how do i e-mail one page only in excel(trial)

B

BWH1952

i am attempting to e-mail one page of a workbook and can not figure out how.
i do not wish to attatch the complete workbook.
 
G

Gord Dibben

If you mean one worksheet and not one "page", you could copy that worksheet to a
new workbook and send that as an attachment.

If you mean one "page" from a worksheet, select and copy then paste into the
body of your email message.

Or File>Send to>mail recipient>send current sheet as message body.

For all Excel email questions get answers at Ron de Bruin's site.

Note the SendMail add-in available as well as the code.

http://www.rondebruin.nl/sendmail.htm


Gord Dibben MS Excel MVP
 

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

Similar Threads

Need Help with Macro Security 1
How to Select Multiple Emails using Surface Pen 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Footnote references on one page, footnote text on the next 5
flashcard file with bad page 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Changing margins on 2nd page of letterhead template 4
Mail Merge Directory Conditional Page Break 0

Top