View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How to send filtered range in email body?

Hi Benny

If you don't use pictures on your sheet you can use the code on my site
http://www.rondebruin.nl/sendmail.htm#body

Look at
http://www.rondebruin.nl/files/SelectionOutlookBody.txt


Or easier use my Add-in for Outlook
http://www.rondebruin.nl/sendmail.htm#Add-in

I hope I have time to test your problem this week


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Benny" wrote in message ...
Hi, I am using a code very similar to the one mentioned in

http://support.microsoft.com/default...b;en-us;816644 ,

except I use advanced filter criteria to mark my range.

The idea is that I send different tasks to different people, and then they reply back to me, filling in the blanks of "their"

sheet.

This works generally well, but a few of them (those with OL2003) suddently see the whole sheet when they reply to the mail.

In OL2002 it was a question of setting "use word to edit emails", but that doesn't work anymore.

Does anybody know if this is a setup problem (Excel or Outlook) or if I need to edit my macro?

I thought that the whole "body" idea was to avoid enclosing the whole sheet...