UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
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: 370



Hi,
'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
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: 27th August 2014 - 10:11 PM