Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2012, 10:47 AM
Fackouch Fackouch is offline Sending open mails automatically Windows 7 32bit Sending open mails automatically Office 2007
Novice
Sending open mails automatically
 
Join Date: May 2012
Posts: 1
Fackouch is on a distinguished road
Question 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending open mails automatically 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 open mails automatically Sending mails Heini Outlook 1 07-19-2009 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft