Send multiple mails with required body of the mail, Attachment, Subject of the mail to specific mail address

[Rohith1324]

Hi,

I have one excel where I have the below details and I'm looking for 1 Click email is sent to all ( Each line one mail to be sent ).

Email Body

Subject line

Attachment location ( Path )

"To" Mail address

"CC" Mail address

Request to someone please help me in automating this.

Regards,
Rohith M

 

[KOKOSEK]

picName = c.Offset(0, 2).Value
if picName="" then
  c.Offset(0, 5).Value = "failed"
else

' HERE THE REST FROM SET OutlookApp
' TO NEXT c

end if

 

[Rohith1324]

picName = c.Offset(0, 2).Value
if picName="" then
  c.Offset(0, 5).Value = "failed"
else

' HERE THE REST FROM SET OutlookApp
' TO NEXT c

end if

Thank you

 

[Rohith1324]

picName = c.Offset(0, 2).Value
if picName="" then
  c.Offset(0, 5).Value = "failed"
else

' HERE THE REST FROM SET OutlookApp
' TO NEXT c

end if

I just wanted to add what ever is there in "Column 3" in HTML Body.

can we do that

 

[KOKOSEK]

Do you want to add attachment path into body of email?

as you wish;

.HTMLBody = .HTMLBody & "<br>" & c.Offset(0, 2).Value

 

[Rohith1324]

Do you want to add attachment path into body of email?

as you wish;

.HTMLBody = .HTMLBody & "<br>" & c.Offset(0, 2).Value

I need one more help in this code.

if 5th Column in my table has the value "ME" then the below code should execute :

.HTMLBody = .HTMLBody & "<br>ExcelAutomat"

IF the 5th Column in my table shows the value " Team" then the below should reflect as :

.HTMLBody = .HTMLBody & "<br>ExcelAutomatTeam"

can you please help

 

[KOKOSEK]

I believe that only ME & TEAM are option:

.HTMLBody = .HTMLBody & "<br>ExcelAutomat" & IIf(c.offset(0,4).value = "ME", "", "TEAM")