I have been using Outlook Express until this month, and have been sending
information from a selected range in an Excel worksheet to a number of people
every month. I don't want to send the entire (large) worksheet as an
attachment, but my "Mail Recipient" function has apparently been disabled
since installing Windows Live Mail. The only "mail" option I see remaining
is to mail the entire document as an attachment, which really isn't an option.
Since I send this information out to about 50 recipients each month, and
each recipient has different data, it's been tedious enough already. But
now, I'm looking for a way to send the data using Windows Live Mail without
having to cut and paste all afternoon.
If there is a way to efficiently do this using a Macro, that would be even
better...
Thanks,

Have you considered the Camera tool in Excel? You can take live snapshots of
just the specific cell ranges you want and paste those "always live"
snapshots to a new worksheet. Then you can just copy & paste that sheet in
its entirety, making it much less tedious.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"RayS1010" wrote:

I have been using Outlook Express until this month, and have been sending
information from a selected range in an Excel worksheet to a number of people
every month. I don't want to send the entire (large) worksheet as an
attachment, but my "Mail Recipient" function has apparently been disabled
since installing Windows Live Mail. The only "mail" option I see remaining
is to mail the entire document as an attachment, which really isn't an option.
Since I send this information out to about 50 recipients each month, and
each recipient has different data, it's been tedious enough already. But
now, I'm looking for a way to send the data using Windows Live Mail without
having to cut and paste all afternoon.
If there is a way to efficiently do this using a Macro, that would be even
better...
Thanks,