How to add multiple emails to "To:" or "Cc:"

[Shewie]

Hi,

I wrote a code to send an email from Excel, but I have a problem:
I want to send an email to multiple emails that are in a cell, but when I run the code it only shows the first one OR it stops running.

I tried to separate the emails with ";", but it didn't work.

.To = Range ("A1")

A1 value is "xyz@gmail.com aaa@gmail.com yyy@gmial.com"

How should I write my email list or how should I fix the code inside VBA?

Thanks a lot!

 

[corppunishment11]

So you are or are not doing a mail merge? Also, you have all of the emails in the same cell rather than being seperated out?

 

[Shewie]

Yes, I've all the emails in the same cell