Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default saving email with CDO

I am able to send email with CDO but is there a way to simply save it as a
DRAFT email rather than sending it straight away to the recipient

e.g
Dim cdoConfig As CDO.Configuration
Dim cdoMessage As CDO.Message

..Send is an option but I do not see a .Save as an option.

Thanks in advance for any help.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default saving email with CDO

Hi Scotty

Not that I know of

See also
http://www.rondebruin.nl/cdo.htm

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



"Scotty" wrote in message ...
I am able to send email with CDO but is there a way to simply save it as a
DRAFT email rather than sending it straight away to the recipient

e.g
Dim cdoConfig As CDO.Configuration
Dim cdoMessage As CDO.Message

.Send is an option but I do not see a .Save as an option.

Thanks in advance for any help.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default saving email with CDO

Ron,

Thank you for your comprehensive help with CDO, you website is awesome.

Is there any other way to achieve the saved mail scenario? In other words
could I use my own MS Outlook to create and save a draft email with an Excel
attachment.

Thanks in advance.
Cheers,

Scotty.

"Ron de Bruin" wrote:

Hi Scotty

Not that I know of

See also
http://www.rondebruin.nl/cdo.htm

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



"Scotty" wrote in message ...
I am able to send email with CDO but is there a way to simply save it as a
DRAFT email rather than sending it straight away to the recipient

e.g
Dim cdoConfig As CDO.Configuration
Dim cdoMessage As CDO.Message

.Send is an option but I do not see a .Save as an option.

Thanks in advance for any help.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default saving email with CDO

Hi Scotty

If you use Outlook code you can use Save instead of Send

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



"Scotty" wrote in message ...
Ron,

Thank you for your comprehensive help with CDO, you website is awesome.

Is there any other way to achieve the saved mail scenario? In other words
could I use my own MS Outlook to create and save a draft email with an Excel
attachment.

Thanks in advance.
Cheers,

Scotty.

"Ron de Bruin" wrote:

Hi Scotty

Not that I know of

See also
http://www.rondebruin.nl/cdo.htm

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



"Scotty" wrote in message ...
I am able to send email with CDO but is there a way to simply save it as a
DRAFT email rather than sending it straight away to the recipient

e.g
Dim cdoConfig As CDO.Configuration
Dim cdoMessage As CDO.Message

.Send is an option but I do not see a .Save as an option.

Thanks in advance for any help.






Reply
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
Need help with formatting / saving before I email my worksheet ExcelUser Excel Discussion (Misc queries) 9 July 15th 09 09:16 PM
Saving email attachments Dixon7 Excel Discussion (Misc queries) 8 July 8th 09 05:43 PM
Saving email addresses from excel document Don Barley Excel Discussion (Misc queries) 1 July 25th 08 01:13 AM
Saving Excel spreadsheet from a email gurowar Excel Discussion (Misc queries) 1 June 4th 08 06:37 PM
Saving email attachments ir26121973 Excel Programming 4 March 29th 06 09:26 PM


All times are GMT +1. The time now is 07:00 PM.

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

About Us

"It's about Microsoft Excel"