counterpart
New Member
- Joined
- Nov 16, 2017
- Messages
- 1
Hi- I've watched dozens and dozens of youtube videos and I can't figure this out. A1 and B1 are both formulas based on other cells and if they meet certain criteria they say 'Send Reminder' or they are blank. They pull from other cells so one could be blank and the other not. I want to create a VBA command that generates an email to the address is C1 if either A or B or both say 'Send Reminder'. Is there a way to make A2 'PO # Needs Extension' as the subject of that email? Thanks a million!
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Send Reminder[/TD]
[TD]Send Reminder[/TD]
[TD]email@email.com[/TD]
[/TR]
[TR]
[TD]PO # Needs Extension[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Send Reminder[/TD]
[TD]Send Reminder[/TD]
[TD]email@email.com[/TD]
[/TR]
[TR]
[TD]PO # Needs Extension[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]