Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send filtered range in email body?
Hi, I am using a code very similar to the one mentioned i
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send filtered range in email body?
Thanks for the reply, but I've already tried using your code, and I couldn't get it to work the way I wanted it to, until I used the link to MS from your site (I am using OL2002-SP2 myself)
Anyway, yesterday I didn't have the code to attach, but here it is (the macro contains several of these blocks) XX Columns("A:H").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range ("K9:L11"), Unique:=Fals Range("A1").Selec Range(Selection, Selection.End(xlToRight)).Selec Range(Selection, Selection.End(xlDown)).Selec If Selection.Rows.Count < 3 Then GoTo YY ' Show the envelope on the ActiveWorkbook ActiveWorkbook.EnvelopeVisible = Tru With ActiveSheet.MailEnvelop .Introduction = "Please reply only once a week. .Item.To = "XX .Item.Subject = "Maintenance and calibration .Item.Sen End Wit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send a Sheet as body of Outlook Email | Excel Discussion (Misc queries) | |||
How to send as email body only the selected page of a worksheet | Excel Discussion (Misc queries) | |||
Trying to send an email with body text, to a range of cells | Excel Discussion (Misc queries) | |||
Range of Cells to create body of email | Excel Worksheet Functions | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |