Need to add CC field to the Code

**nasin123** · 09-28-2021, 09:42 AM

Hey Guys,

I am using the below code to run the macro to send out emails using outlook.

Could you please help in amending it and adding few lines of code to include a CC field as well ( where we can add emails Id to be CCed)? Right now, I put email Id for "To" part in one column and i want to add CC email IDs in a separate column.

Please Login or Register  to view this content.

**WideBoyDixon** · 09-28-2021, 09:57 AM

Please Login or Register  to view this content.

WBD

**nasin123** · 09-28-2021, 10:33 AM

Sorry. This doesn't work. For CC, need to capture values from excel tab and it will not be one email ID that will be CCed. "CC" Will be different for each email. Is there a way to include this in the code?

**jolivanes** · 09-28-2021, 11:15 AM

Have you checked this site?
https://www.rondebruin.nl/win/s1/outlook/mail.htm

**nasin123** · 09-28-2021, 04:57 PM

Yup. But this doesn't specifically answer the question of including CC in the code

Please help

**bakerman2** · 09-28-2021, 05:23 PM

Please Login or Register  to view this content.

**nasin123** · 09-28-2021, 05:56 PM

Thank you. I tried after including this line, but i am getting type mismatch error. I am sure i am missing something. Could you please help.

Please Login or Register  to view this content.

**bakerman2** · 09-28-2021, 06:02 PM

Offset requires numbers.

You examine cells in Column B so cell.Offset(, 1) for Column C value , cell.Offset(, 2) for Column D value and so on.....

**nasin123** · 09-28-2021, 06:05 PM

Sorry.. i realized this mistake after posting comment. I did change that to column no. and now i get error at below line and getting error " Outlook doesn't recognize one or more name"

Code stops at this line.

Please Login or Register  to view this content.

**bakerman2** · 09-28-2021, 06:17 PM

Works fine for me.

Please Login or Register  to view this content.

**nasin123** · 09-28-2021, 06:25 PM

Sorry.. my file currently picks Email Id for "To" Part of email from column B and Column D till Z are reserved for attachments. So situation is that column B will be populated with email ids ( which will be different in each row) which should be kept in "To" part of email and i want Column C ( which again will include different email ids for each row) to include email ids which should be CCed for each email. Hence, the code need to be amended to accommodate the column C part only.

code which you just posted works for one specific email for To and CC. Could you please help in updating the code to accommodate this requirement. Really appreciate all the efforts.

**WideBoyDixon** · 09-28-2021, 06:55 PM

Please Login or Register  to view this content.

**nasin123** · 09-28-2021, 07:01 PM

Thank you Thank you Thank you! This works absolutely fine.

Need to add CC field to the Code

LinkBack

Thread Tools

Rate This Thread

Display

Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Re: Need to add CC field to the Code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Display a code based on if there is value in a field

Pivot Table Calculated Field - Each Item in Field B as % of Total of Field A

[SOLVED] PowerPivot: Merge Month Field and Year Field Into a Date Field

VBA: Reset Field Code

Calculated Field in Pivot Table Based on One Summed Field and one Counted Field

Adding field to calculate sum of a field and count of a field in pivot table

[SOLVED] Code to unfilter one field only

Bookmarks

Bookmarks

Posting Permissions