VBA Open Outlook template based on cell value then email then repeat next row

[rplohocky]

Hello,
I'm looking for code that will open a specific Outlook template based on what is in cell H1, allow to add 3 different cell values to the subject line, then email, automatically, and then move to the next row and do the same thing until there's no more populated rows.

I have 3 different templates saved in a folder on my desktop. The file extension is .msg.

It would look like this...
if H1 says "Assigned" then open template "ASSIGNED" and then grab the data from cell A1 and place in the subject line and then from B1 and C1.

The subject line would look like this...

Driver Add Request Fleet (FROM B1) Workflow# (FROM A1) / (FROM C1)

Any help would be great!

 

[Worf]

Remove the “on error resume next” statement. If an error happens, tell me its number and what the offending code line is.

 

[Worf]

Remove the “on error resume next” statement. If an error happens, tell me its number and what the offending code line is.

 

[rplohocky]

Remove the “on error resume next” statement. If an error happens, tell me its number and what the offending code line is.

Worf,
All is well and works great! Thanks for all your help!