ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Email current page (https://www.excelbanter.com/excel-discussion-misc-queries/204746-email-current-page.html)

Mike

Email current page
 
Hi all,

Did a quick search of the subject but could not locate anything. In office
2003 you could email the current page OR the whole workbook. In office 2007
it appears the only option is to email the whole workbook. Is there any way
in office 2007 that you can just email the current page without going to the
effort of copying the the page into a new workbook and then sending that
workbook?

Kindest regards,
--
Mike B

JP[_4_]

Email current page
 
Mike,

Did you check this page?

http://rondebruin.nl/sendmail.htm

--JP

On Oct 1, 9:33*pm, Mike wrote:
Hi all,

Did a quick search of the subject but could not locate anything. In office
2003 you could email the current page OR the whole workbook. In office 2007
it appears the only option is to email the whole workbook. Is there any way
in office 2007 that you can just email the current page without going to the
effort of copying the the page into a new workbook and then sending that
workbook?

Kindest regards,
--
Mike B



Mike

Email current page
 
Hi JP,

Thanks for your reply, I will have a look at the code and see if we can
successfully use one of them. I think though that Office 2003 did it
natively, but I will stand corrected if this was not the case. At least the
macros provided on the page you listed will be a solution to play with.

Kindest regards and many thanks,
--
Mike B


"JP" wrote:

Mike,

Did you check this page?

http://rondebruin.nl/sendmail.htm

--JP

On Oct 1, 9:33 pm, Mike wrote:
Hi all,

Did a quick search of the subject but could not locate anything. In office
2003 you could email the current page OR the whole workbook. In office 2007
it appears the only option is to email the whole workbook. Is there any way
in office 2007 that you can just email the current page without going to the
effort of copying the the page into a new workbook and then sending that
workbook?

Kindest regards,
--
Mike B




JP[_4_]

Email current page
 
Good luck and write back if you have further questions.

--JP

On Oct 2, 1:05*am, Mike wrote:
Hi JP,

Thanks for your reply, I will have a look at the code and see if we can
successfully use one of them. I think though that Office 2003 did it
natively, but I will stand corrected if this was not the case. At least the
macros provided on the page you listed will be a solution to play with.

Kindest regards and many thanks,
--
Mike B



"JP" wrote:
Mike,


Did you check this page?


http://rondebruin.nl/sendmail.htm


--JP



Ron de Bruin

Email current page
 
This is what you are looking for Mike
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm


--

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


"Mike" wrote in message ...
Hi JP,

Thanks for your reply, I will have a look at the code and see if we can
successfully use one of them. I think though that Office 2003 did it
natively, but I will stand corrected if this was not the case. At least the
macros provided on the page you listed will be a solution to play with.

Kindest regards and many thanks,
--
Mike B


"JP" wrote:

Mike,

Did you check this page?

http://rondebruin.nl/sendmail.htm

--JP

On Oct 1, 9:33 pm, Mike wrote:
Hi all,

Did a quick search of the subject but could not locate anything. In office
2003 you could email the current page OR the whole workbook. In office 2007
it appears the only option is to email the whole workbook. Is there any way
in office 2007 that you can just email the current page without going to the
effort of copying the the page into a new workbook and then sending that
workbook?

Kindest regards,
--
Mike B





All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com