Hi, I have columns of information that I would like to have a macro open up the email based on criteria and insert all the fields and then leave it open so that I can attach a pdf to the email.
<colgroup><col><col><col><col span="4"></colgroup><tbody></tbody>
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
the number 3 = is counting how many rows contain the criteria "Snail"
January is the month I would like included in the subject
This is what I would like in the email:
To: Email 1
CC: Email 2; Email 3 - If there is any
Subject: January (H1) Invoice for "District Short"
Messsage: Attached is your Snail Invoice. If you have any questions please contact the lifeguard
Thank you,
I have tried researching several different VBA examples but I couldn't narrow it down to what I needed. I am still learning.
Thanks in advance!!
<colgroup><col><col><col><col span="4"></colgroup><tbody></tbody>
DistrictShort | Service | Email 1 | Email 2 | Email 3 | 3 | January |
Beach | Beach@me.com | |||||
Ocean | snail | Ocean@me.com | ||||
Salt | snail | Salt@me.com | ||||
Dolphin | Dolphin@me.com | |||||
Monkey | Monkey@me.com | |||||
Sharks | snail | Sharks@me.com | ||||
Jellyfish | Jellyfish@me.com |
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
the number 3 = is counting how many rows contain the criteria "Snail"
January is the month I would like included in the subject
This is what I would like in the email:
To: Email 1
CC: Email 2; Email 3 - If there is any
Subject: January (H1) Invoice for "District Short"
Messsage: Attached is your Snail Invoice. If you have any questions please contact the lifeguard
Thank you,
I have tried researching several different VBA examples but I couldn't narrow it down to what I needed. I am still learning.
Thanks in advance!!