Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Email With attachments

Hello,

I have read previous threads and have successfully implemented the email
with attachments VBA code.

However I want to extend this to include the CC operator.

My directory contains the following headings: Email | CC | Attachment1 |....

I need the code to also include the corresponding line value in the CC column.

Any help you can give would be great.

T
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Email With attachments

If you use the SendMail code it is not possible to use CC
You can use the Outlook object model or CDO

See this page
http://www.rondebruin.nl/sendmail.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Twisty1980" wrote in message ...
Hello,

I have read previous threads and have successfully implemented the email
with attachments VBA code.

However I want to extend this to include the CC operator.

My directory contains the following headings: Email | CC | Attachment1 |....

I need the code to also include the corresponding line value in the CC column.

Any help you can give would be great.

T

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
Cannot open .xls attachments from email Meredith Setting up and Configuration of Excel 4 January 4th 08 07:58 AM
email with attachments from list kristin Excel Discussion (Misc queries) 1 September 28th 07 07:01 PM
Email attachments Holden Caulfield New Users to Excel 1 April 20th 07 02:00 AM
Send an email, some with/without attachments [email protected] Excel Discussion (Misc queries) 0 January 22nd 07 08:34 PM
Email Attachments Broken Up [email protected] Excel Discussion (Misc queries) 0 January 12th 05 03:01 PM


All times are GMT +1. The time now is 10:29 AM.

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"