|
|
#1
08-13-2015, 03:22 AM
|
|||
|
|||
need assistance in send mail macro
Hi guys, Please find attached sheet. If we click on validate button it highlights all cells in mandatory columns which are blank and pops up a message on the screen stationg "Please fill up mandatory fields. My question is if there are no blanks in the mandatory columns. then macro should not pop up that message it should draft an email. i have designed the code but its either highlighting blanks cells or drafting email. am not bale to combine both the things. kindly assist. 
|
| Tags |
| mail macro, validation |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro code should find inv no in folder and send attachhed mail. | visha_1984 | Outlook | 0 | 01-30-2013 05:08 AM |
| Hijacked e mail send. | igardos44 | Outlook | 0 | 05-24-2012 07:32 AM |
 Send e-mail by macro
|
plamenbv | Excel Programming | 1 | 04-16-2012 05:25 AM |
| Cant Send E-Mail | dmack98 | Outlook | 0 | 03-09-2012 10:59 AM |
|
send/receive mail every 5 min.?
|
bsoderror | Outlook | 2 | 07-06-2009 04:36 AM |
Windows XP 
Office 2010 32bit
Threaded Mode