LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
a a is offline
external usenet poster
 
Posts: 51
Default Emailing files using a do until

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Emailing files from Excel 2007 Tommy H Excel Discussion (Misc queries) 2 January 29th 10 09:12 PM
emailing files from excel, the files will not go until I open up . joe New Users to Excel 2 September 18th 09 02:12 PM
Emailing Linked Excel Files SandyH Excel Discussion (Misc queries) 0 July 14th 09 03:20 PM
emailing excel files jayare Excel Discussion (Misc queries) 0 March 30th 06 12:46 PM
Emailing files changes formatting Kim Excel Discussion (Misc queries) 1 June 7th 05 10:07 PM


All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"