How do i read email from excel file and send in outlook?

[SIM_JUN_HUI_BERTRAM_CSOD]

Hey guys, im not sure how to read the excel file containing the emails to be send in outlook i tried reading the excel file containing the email in one cell but idk how to proceed to actually send it out. I have also tried using string eg HTEmail in the “To” box.

Here is an example of reading from the excel file in the cell

[Yameso (Jakub Swiderski)]

When you read range your excel, you shoud use then for each row activity in that data table. Inside there you should paste send Outlook Mail Message, with property “To:” as row(1).toString

[Yameso (Jakub Swiderski)]

In short way it should look like this:

[SIM_JUN_HUI_BERTRAM_CSOD]

ohh thanks i was using the other for each loop using the workbook application

[SIM_JUN_HUI_BERTRAM_CSOD]

Sorry i want to ask again i got an error saying this even tho i put my email in the cell. How should i put the name n email in the cell?

[Yameso (Jakub Swiderski)]

Instead of send outlook mail message you can use message box to print what value is under “row(1).toString”. Then you can try to correct it before sending email

[SIM_JUN_HUI_BERTRAM_CSOD]

thks erm but i got one last question to ask since i have put my emails under column B but it is reading all the emails under column B. i just want column B2 email in the excel file how do i do it?