View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nate Oliver[_4_] Nate Oliver[_4_] is offline
external usenet poster
 
Posts: 8
Default Mail a row to each person in a range (HTML) - by Ron de Bruin

Hello,

I'm not quite sure how your function would know what the range in
question is, at a glance. And with the way you've tabbed the code, or
lack thereof, that glance was trying...

You might be better off trying to use a single in-line procedure, e.g.,

http://www.danielklann.com/excel/sen...s_the_body.htm

The one thing I might add, would be to delete the temp. file once
you're done with it. You might use the Kill statement for this, but
I've had mixed results with this in the past..

I prefer to use the DeleteFile API function, never had a problem with
it. See the following:

http://www.mentalis.org/apilist/DeleteFile.shtml

Regards,
Nate Oliver