1 / 69
文档名称:

用VBA操纵Lotus notes发邮件.doc

格式:doc   大小:3,231KB   页数:69页
下载后只包含 1 个 DOC 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

分享

预览

用VBA操纵Lotus notes发邮件.doc

上传人:业精于勤 2019/9/24 文件大小:3.16 MB

下载得到文件列表

用VBA操纵Lotus notes发邮件.doc

相关文档

文档介绍

文档介绍:用VBA操纵Lotusnotes发邮件287,用lotusnotes发送邮件,第一种方法,SubSendWithLotus()DimnoSessionAsObject,noDatabaseAsObjectDimnoDocumentAsObject,noAttachmentAsObjectDimFileSelfAsStringDimiAsLongConstEMBED_ATTACHMENT=1454ConststSubjectAsString="ForLotusVBAProgrammingTestonly"DimstMsgAsStringFileSelf=+"\"+="Bst&Rgds"&vbCrLf&&vbCrLf&_vbCrLf&_"**************************************************************************"&vbCrLf&_"(This'sanautomatede-mailnotification,pleasedonotreplythismessage.)"DimvaRecipientAsVariantvaRecipient=("huangfeng8211@")'=CreateObject("")SetnoDatabase=("","D:\notes\data\mail3\")===("Body"),"",="Memo".SendTo=====Now().SEND0,vaRecipientEndWithSetnoDocument=NothingSetnoDatabase=NothingSetnoSession=NothingAppActivate"MicrosoftExcel"MsgBox"Thisfilebesent",vbInformationEndSub第二种方法SubSendWithLotus()DimnoSessionAsObject,noDatabaseAsObjectDimnoDocumentAsObject,noAttachmentAsObjectDimvaFilesAsVariantDimiAsLongConstEMBED_ATTACHMENT=1454ConststSubjectAsString="ForLotusVBAProgrammingTestonly"ConststMsgAsString="Thisfileisforyou!justforreference"&vbCrLf&"IamStanleyPan"DimvaRecipientAsVariantvaRecipient=("stanleypan2000@","@")vaFiles=(FileFilter:="ExcelFiler(*.xls),*.xls",Title:="AttachfilesforoutgoingE_Mail",MultiSelect:=True)IfNotIsArray(vaFiles)ThenExitSub'=CreateObject("")SetnoDatabase=("","D:\notes\data\mail3\")===("Body")WithnoAttachmentFo