|
公司写的代码,可以将数据直接写到新邮件中
Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEMail_Click
Dim PartDisposition As Variant
Select Case Me.Disposition
Case 1
PartDisposition = "Rework"
Case 2
PartDisposition = "Use As Is"
Case 3
PartDisposition = "Scrap"
Case 4
PartDisposition = "Return for Credit"
Case 5
PartDisposition = "Inventory Issue"
End Select
If Me![txtMIDNumber] <> "" Then
DoCmd.SendObject , , , , , , "Please review NCR # " & Me.MIDNumber, _
"NCR Number = " & Me.MIDNumber & vbCrLf & _
"Part Number = " & Me.PartNumber & vbCrLf & _
"Part Description = " & Me.PartDescription & vbCrLf & _
"Casting Number = " & Me.CastingNumber & vbCrLf & _
"Casting Description = " & Me.CastingDescription & vbCrLf & _
"WO/PO Number = " & Me.WONumber & vbCrLf & _
"NCR Disposition = " & PartDisposition & vbCrLf & _
"Vendor = " & Me.VendorName & vbCrLf & _
"Quantity = " & Me.Quantity & vbCrLf & _
"Comments :" & vbCrLf & _
Me.MIDInformation & vbCrLf & _
vbCrLf & "Manufacturing Comments :" & vbCrLf & _
Me.ManufacturingNotes & vbCrLf & _
vbCrLf & "Production Comments :" & vbCrLf & _
Me.ProductionNotes & vbCrLf & _
vbCrLf & "Purchasing Comments :" & vbCrLf & _
Me.PurchasingNotes & vbCrLf & _
vbCrLf & "Warehouse Comments :" & vbCrLf & _
Me.WarehouseNotes & vbCrLf & _
vbCrLf & "Additional Comments :" & vbCrLf & _
Me.AdditionalComments
Else
MsgBox "Select MID # first", vbCritical, "Error"
End If
Exit_cmdEMail_Click:
Exit Sub
Err_cmdEMail_Click:
MsgBox "E-Mail is currrently not working. Try again later", vbCritical
Resume Exit_cmdEMail_Click
End Sub
请看附件图片,点击邮件图标(图1)直接写的OUTLOOK中(图2),再添加收件人
请大家看看是否可以添加收件人 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|