PDA

View Full Version : send email and cc another person in range in html body



ctw1234
03-06-2011, 04:50 PM
Hi there, I am new to vba...

Can someone help me to send email to my customers and cc their alternative address with their orders in email body. I would like to send one email per customer.

attached is the file.. Thanks in advance.

UngV
03-07-2011, 07:49 AM
What email client are you using? It will make a difference to the code required.

Tinbendr
03-07-2011, 08:46 AM
Here are a few articles. (http://www.rondebruin.nl/sendmail.htm)

ctw1234
03-07-2011, 08:59 AM
will be using outlook for sending the email. Was thinking to use the code for Mail a row or rows to each person in a range (HTML) but couldn't figure out the cc part. Thanks.