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 Emailing files using a do until

Hi a

Maybe
http://www.rondebruin.nl/mail/folder2/files.htm


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



"a" wrote in message .net...
Hi,

I have to email files to a large number of people on a monthly basis. I use templates - but I have seen that you can use an array
to email the files. I tried using code that I found in a book and also from the help in VBA. I always get the message that I
need to close excel and email and try again because of . . ., I'm not sure of the exact wording.

My plan is to have a sheet in a file that would look at a column in a worksheet to see which file I want to send and then, in
another column, the recipient. I want it to loop until there are no more files.

I cannot even get to the first part of the code without getting the error message that I described above.

Would any of you have idea on why I cannot get this to work? I am using Netscape - which may make a difference - though I can do
it manually with no problem.

Any help would be much appreciated.

Thanks in advance,
Anita