UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Email    
 
   
John_Ross
post Apr 4 2012, 10:48 AM
Post #1

UtterAccess Veteran
Posts: 343



Hi,

I've a send email code in Excel that works fine but I would like to view the emails that the code generates instead of it sending it automatically. How do I view the emails first in Outlook before it sends out automatically?

Thank you.
Go to the top of the page
 
+
ipisors
post Apr 4 2012, 10:53 AM
Post #2

Banned
Posts: 9,239



Depends on what code you're using, can you post a sample?

My guess is you may have a line like this:

olMail.Send

and you may need to change it to

olMail.Display

where "olMail" (or whatever you have) is the variable name for the actual mail item



This post has been edited by ipisors: Apr 4 2012, 10:55 AM
Go to the top of the page
 
+
ipisors
post Apr 4 2012, 10:56 AM
Post #3

Banned
Posts: 9,239



PS, all of what I said applies only if you're actually manipulating Outlook, either thru early or late binding (Outlook library reference, or Create Object). If you're using something like ThisWorkbook.SendMail, then I'm not entirely sure...post the code you're using now
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 24th April 2014 - 11:07 AM