Help!!
I am trying to use VBA to send along a sheet . The code works for everything but the return reciept.
Does anyone have expirience in Lotus Notes being used from VBA????
'send the mail
Application.Dialogs(xlDialogSendMail).Show _
arg1:="someone@somewhere", _
arg2:=Range("d4") & " CRITERIA TRANSMITTAL FROM " & Range("c29"), _
arg3:=ReturnReceipt
I have tried looking in the Lotus notes help and this is what they gave.
Syntax
@MailSend
@MailSend( sendTo ; copyTo ; blindCopyTo ; subject ; remark ; bodyFields ; [ flags ] )
The available flags are:
[Sign]
Electronically sign the memo when mailing it, using information from the user's ID. Signing will not occur unless you include this flag.
[Encrypt]
Encrypt the document using the recipient's public key, so that only the recipient whose private key matches can read the document. Encryption will not occur unless you include this flag.
[PriorityHigh]
Immediately routes the message to the nexthop server as defined by the combination of Mail Connection records and server records. If a phone call has to be made in order to route the message, then the call is placed immediately, regardless of the schedule set in the Remote Connection record. If you omit this flag, the priority defaults to Normal.
[PriorityNormal]
Routes the message to the nexthop server based on the schedule defined in the Mail Connect records. If the recipient's mail file resides on a server on the same Domino network, then delivery occurs immediately. If you omit this flag, the priority defaults to Normal.
[PriorityLow]
Routes the message overnight if the recipient's mail file does not reside on a server on the same Notes/Domino network. If the recipient's mail file does reside on a server on the same Notes/Domino network, then delivery occurs immediately. Low Priority mail can also be controlled by a Notes/Domino environment variable called MailLowPriorityTime=x, where x is equal to a number from 0 to 23. When placed in the server notes.ini file, this variable tells the server when to route Low Priority mail. If you omit this flag, the priority defaults to Normal.
[ReturnReceipt]
Notify the sender when each recipient reads the message. No receipt is returned unless you include this flag.
[DeliveryReportConfirmed]
Notify the sender whether delivery of the memo was successful or not. By default, the Basic delivery report is used, which notifies the sender only when a delivery failure occurs.
Any clues???
I need this to have a return reciept or I cant use it..........
MAny thanks
I am trying to use VBA to send along a sheet . The code works for everything but the return reciept.
Does anyone have expirience in Lotus Notes being used from VBA????
'send the mail
Application.Dialogs(xlDialogSendMail).Show _
arg1:="someone@somewhere", _
arg2:=Range("d4") & " CRITERIA TRANSMITTAL FROM " & Range("c29"), _
arg3:=ReturnReceipt
I have tried looking in the Lotus notes help and this is what they gave.
Syntax
@MailSend
@MailSend( sendTo ; copyTo ; blindCopyTo ; subject ; remark ; bodyFields ; [ flags ] )
The available flags are:
[Sign]
Electronically sign the memo when mailing it, using information from the user's ID. Signing will not occur unless you include this flag.
[Encrypt]
Encrypt the document using the recipient's public key, so that only the recipient whose private key matches can read the document. Encryption will not occur unless you include this flag.
[PriorityHigh]
Immediately routes the message to the nexthop server as defined by the combination of Mail Connection records and server records. If a phone call has to be made in order to route the message, then the call is placed immediately, regardless of the schedule set in the Remote Connection record. If you omit this flag, the priority defaults to Normal.
[PriorityNormal]
Routes the message to the nexthop server based on the schedule defined in the Mail Connect records. If the recipient's mail file resides on a server on the same Domino network, then delivery occurs immediately. If you omit this flag, the priority defaults to Normal.
[PriorityLow]
Routes the message overnight if the recipient's mail file does not reside on a server on the same Notes/Domino network. If the recipient's mail file does reside on a server on the same Notes/Domino network, then delivery occurs immediately. Low Priority mail can also be controlled by a Notes/Domino environment variable called MailLowPriorityTime=x, where x is equal to a number from 0 to 23. When placed in the server notes.ini file, this variable tells the server when to route Low Priority mail. If you omit this flag, the priority defaults to Normal.
[ReturnReceipt]
Notify the sender when each recipient reads the message. No receipt is returned unless you include this flag.
[DeliveryReportConfirmed]
Notify the sender whether delivery of the memo was successful or not. By default, the Basic delivery report is used, which notifies the sender only when a delivery failure occurs.
Any clues???
I need this to have a return reciept or I cant use it..........
MAny thanks