#1
|
|||
|
|||
Sending open mails automatically
Hi guys,
I'm having a problem getting around this. I have a Macro in excel that run and pull data from database and then send a mails. This works fine. After the macro runs, about 32 Emails are generated. I'm just wondering if there is a way to send them automatically without going through each one and click Send? I wrote the following but didn't work. I'm only new in outlook VB.. Sub send_all() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application. objMail.Send end sub Any sugessions? Thanks, Pat |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sending multiple mails | cleavermike | Outlook | 2 | 07-15-2011 02:22 PM |
Outlook 2010 - Too long to Start Sending E-mails | HugoCore | Outlook | 2 | 06-08-2011 04:14 PM |
POP3 mails sending problem | swaminathan | Outlook | 1 | 05-09-2011 03:54 AM |
Problem Sending *SOME* E-Mails | kdavis | Outlook | 6 | 02-17-2011 04:03 PM |
Sending mails | Heini | Outlook | 1 | 07-19-2009 05:27 AM |