ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Email With attachments (https://www.excelbanter.com/excel-discussion-misc-queries/187987-email-attachments.html)

Twisty1980

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

Ron de Bruin

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



All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com