Re: Send email

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?
Perry wrote:
replace
objOutlookMsg.Display

by
objOutlookMsg.Send

Hey I have this code for sending email which I get it from MS HELP.
I want to send email when txtAgedDay = -1 and I want it to automatically
[quoted text clipped - 45 lines]
Set objOutlook = Nothing
End Sub

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • RE: Create a "cell button" to hide selected cells.
    ... To avoid cluttering up the worksheet with controls, I used a UserForm. ... The user clicks a button on the worksheet to display a UserForm ... Private Sub cmdSetWeeksToShow_Click ...
    (microsoft.public.excel.worksheet.functions)
  • Re: What am I doing wrong?
    ... I do not like a single display, prefering a Flex Grid to display all of the ... Dim rstCompany As Recordset ... Set rstCompany = Nothing ... Private Sub CmdUpdate_Click ...
    (microsoft.public.vb.database.dao)
  • Re: Hardware hackers rejoice!
    ... I've tried to warm up to Perl ... sub getvar { ... # Given 0, the fan is off. ... # Display to LCD ...
    (Ubuntu)
  • Re: filter a combobox
    ... the reason for IsError is that the CB2 linked cell B3 will display ... "Dave Peterson" wrote: ... > Did you put the code behind the worksheet with the comboboxes? ... >> Private Sub ComboBox2_Change ...
    (microsoft.public.excel.programming)
  • Re: Next & Previous buttons dont display data correctly in Access
    ... The unbound controls remain ... NOTE - it is only display that is incorrect - the database ... > Exit Sub ... > The custom print button is supposed to print of a report version of the ...
    (microsoft.public.access.forms)