![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
the following works- need message send options for importance, voting, category
based on criteria if approver 2000 then go to name Private Sub CMDSendEmail1_Click() On Error GoTo Err_cmdSendEmail1_Click Dim strEmailMessage As String Dim strCC As String Dim StrRcvdDate As String Dim strDueDate As String Dim StrSubject As String Dim StrImportance As String StrRcvdDate = Forms![Data FORM].Form![DateReceived] 'the due date for signoff 'the text of the message, use chr(10) for line breaks strEmailMessage = "Please review the attached document, Approve or Reject BY Email. Please email Medco Finance Contracts Admin the revised Form." & Chr(10) & Chr(10) & "Thank You!" & Chr(10) & Chr(10) & "Adjustment Administrator" strCC = "Medco Finance Contracts Admin" 'the email address of all ccs strBCC = "" 'the email address of all bccs StrSubject = "Manual Billing Request. Adjustment Form" 'the subject of the email 'strTo = Forms![DataForm]![Form1].Form![UserID] 'the recipient of the email strAttachment = "DATA RPT" 'the name of the attached report StrImportance = "High" 'High importance '"1" DoCmd.SendObject acSendReport, strAttachment, "SnapshotFormat(*.snp)", strTo, strCC, strBCC, StrSubject, strEmailMessage, True, "" If Forms![Data FORM].Form![SaveReport] = -1 Then DoCmd.RunMacro "SaveReport" End If Exit_cmdSendEmail1_Click: Exit Sub Err_cmdSendEmail1_Click: MsgBox Err.Description Resume Exit_cmdSendEmail1_Click End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
multiple line voting options | JudyT | Outlook - Using Forms | 1 | October 2nd 07 03:21 PM |
How to send message to SOME in a category? | mamabookworm | Outlook - Using Contacts | 2 | May 2nd 07 02:33 PM |
Redemption & voting options | Ezio | Outlook and VBA | 4 | February 14th 07 08:36 AM |
can I color code tasks with a category or otherwise make subcatego | Arthur | Outlook - Using Contacts | 1 | April 24th 06 12:37 AM |
How to set send options by code | a | Outlook - General Queries | 0 | March 3rd 06 08:01 AM |