LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default CDO emailing

hi

I'm using a typical code that sends email using CDO objects.

The code has an ".addattachment" method to attach file.

This code is basically in a loop that sends 1 email after another by getting
email addresses from a range of cells.

The objective is to send one attachment per email.

The problem is the .addattachment method keeps stacking up files from
previous attachments as the code loops. The first email would get its
attachment; 2nd email would get its attachment plus that of the first email,
and so on.

How can I clear out this .addattachment method before the next loop ?

Thanks
Steve


 
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 lsherman22 Excel Discussion (Misc queries) 0 January 12th 06 07:35 PM
emailing pdf nickp Excel Discussion (Misc queries) 4 August 8th 05 11:14 AM
emailing IanH Excel Worksheet Functions 4 June 1st 05 09:25 PM
emailing phil Excel Programming 1 April 6th 04 09:13 PM
Emailing in VBA Steven Cheng[_2_] Excel Programming 2 July 25th 03 11:27 PM


All times are GMT +1. The time now is 09:54 PM.

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"