Re: Send email

Help!!!!
EMILYTAN wrote:
What is the difference between .Display and .Send?
I changed already but still cannot send automatically and once I open that
form on that particular record, it send the mail and i open again, it send
again...
I just want it to send automatically once i open the database without opening
the form and send only once....
Any idea?
replace
objOutlookMsg.Display
[quoted text clipped - 7 lines]
Set objOutlook = Nothing
End Sub

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200705/1

.

Relevant Pages

  • Re: Need Macro to Open Access
    ... I went to your suggested site and got Access to open the database I wanted it ... I still have a problem with opening just Access and having it displayed. ... Sub NewAccessOnly() ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Connecting to Access using macro
    ... database but its not opening the tables I want to open: ... Sub Auto_Open ... Dim cn As ADODB.Connection ...
    (microsoft.public.excel.programming)
  • Re: Decompile?
    ... You could try opening another database and running this very old but should ... Public Sub Decompile ... The test sub opens northwind.mdb in a decompiled state. ...
    (comp.databases.ms-access)
  • Re: The Sci-Fi Rejection Letter That Time Forgot
    ... nations have stockpiled arsenals of these incredible bombs and the time the story is set. ...
    (rec.arts.sf.written)
Loading