第一种方法
Sub SendWithLotus()
Dim noSession As Object,noDatabase As Object
Dim noDocument As Object,noAttachment As Object
Dim Fi leSelf As String
Dimi As Long
Co nst EM BED_ATTACHMENT= 1454
Const stSubject As String="For Lotus VBA Programming Test only"
D i m stMsg As Stri ng
Fi leSelf=ThisWorkbook Path+"\"+ThisWorkbook NamestMsg="Bst&Rgds"&vbCrLf&_
Application UserName&vbCrLf&_
"**********************
"(This's an automated e-mai l notification,please do not reply this message)"
DimvaRecipient As VariantvaRecipient=VBA Array("huangfeng8211@163 com")
'Insert Lotus Notes COM object
Set noSession=CreateObject("Notes NotesSession")
Set noDatabase=noSession GETDATABASE("","D:\notes\data\mai l3\tonyhf nsf")
If noDatabase IsOpen= False Then noDatabase OPENMAIL
Set noDocument=noDatabase CREATEDOCUMENT
Set noAttachment= noDocument CREATERICHTEXTITEM("Body")noAttachment EMBED OBJECT EMBED_ATTACHMENT,"" ,Fi leSelf
With noDocument
Fo rm="Memo"
SendTo=vaRecipient
Subject= stSubject
Body= stMsg
SAVEMESSAGEONSEND=True
PostedDate=Now()
SEND 0,vaRecipient
End With
Set noDocument=Nothing
Set noDatabase=Nothing
Set noSession=Nothing
AppActivate"Microsoft Excel"
MsgBox"This fi le be sent" ,vbInformation
EndSub
第二种方法
Sub SendWithLotus()
Dim noSession As Object,noDatabase As Object
Dim noDocument As Object,noAttachment As Object
Dim vaFi les As Variant
Dimi As Long
Co nst EM BED_ATTACHMENT= 1454
Const stSubject As String="For Lotus VBA Programming Test only"
Const stMsg As Stri ng="This fi le is for you!j ust for reference"&vbCrLf&"I am StanleyPan"
DimvaRecipient As VariantvaReci pi ent=VBA Array("stan leypan2000@hotmai l com" ,"stanley pan@Iso laAg com")vaFi les = ApplicationGetOpenFi lename(Fi leFi lter:="Excel Fi ler (*xls),*xls" , Title:="Attach fi les for outgoing E_Mai l" ,MultiSelect:=True)
If Not IsArray(vaFi les)Then Exit Sub
'Insert Lotus Notes COM object
Set noSession=CreateObject("Notes NotesSession")
Set noDatabase=noSession GETDATABASE("","D:\notes\data\mai l3\tonyhf nsf")
If noDatabase IsOpen= False Then noDatabase OPENMAIL
Set noDocument=noDatabase CREATEDOCUMENT
Set noAttachment= noDocument CREATERICHTEXTITEM("Body")
With noAttachment
For i =1 To UBound(vaFi les)
EMBED OBJECT EMBED_ATTACHMENT,"",vaFi les(i)
Next i
End With
With noDocument
Fo rm="Memo"
SendTo=vaRecipient
Subject= stSubject
Body= stMsg
SAVEMESSAGEONSEND=True
PostedDate=Now()
SEND 0,vaRecipient
End With
Set noDocument=Nothing
Set noDatabase=Nothing
Set noSession=Nothing
AppActivate"Microsoft Excel"
MsgBox"Thisfi le is send OK" ,vbInformation
EndSub
a,返回当前数据库的名称
结果
b,返回当前数据库的文件名
c,返回当前数据库的文件路径
Sub aaaaaa()
Dimno AsObject
Dim db As Object
Dim doc As Object
Dim fields As Object
Dim nofields As Object
Dimatt As Variantatt=ApplicationGetOpenFi lename(Fi leFi lter:="Excel Fi ler(*xls),*xls" ,_
Title:="Attach fi les for outgoing E_Mai l" ,MultiSelect:=True) '添加附件
Set no=CreateObj ect("notes notessession")'建立和邮件的连接
Set db=no CURRENTDATABASE'建立和邮件数据库的连接
Set doc=db CREATEDOCUMENT'创建一个新的邮件
Set fields=doc CREATERICHTEXTITEM("body") '设置新邮件的正文附件对象With fields'设置邮件的正文和附件
APPENDTEXT" this e-mai l is generated by an automated processjust for a test"ADDNEWLINE 1 '增加第一行
APPENDTEXT" please do not reply"
ADDNEWLINE 2 '增加第二行
For i = 1 To UBound(att) '添加附件
E MB ED OB J E CT 1454,"" ,att(i)
Next i
EndWith
With doc '设置新邮件的除正文和附件外的其他信息form= "Memo" '新邮件sendto=VBA Array("huangfeng8211@163 com" ,"tonyhf@cn i bm com") '发送给Subject= "this mai l isjust for testing" '主题
SAVEMESSAGEONSEND=True'是否保存发送的邮件到发件箱postdate=DateAdd("d" ,1,Date) '发送日期等于当天
SEND0'发送
EndWith
MsgBox"successfully sent out the mai l!"
Set no=Nothing'释放内存
Set db=Nothing
Set doc=Nothing
Set fields=Nothing
EndSub
在添加附件的时候如果只是想将当前的活动工作薄作为附件的话如下
注意一下,如果是1452的话,效果如下,
会出现一个提示,询问文档包含外部对象链接,是否要更新链接,如果确定的话,效果如下,会将EX CEL文件中的内容以图片形式打开,同时文件是只读格式的,
如果是1453,效果如下,
不会有提示,但是文件为只读,
如果为1454,则为正常的EX CEL文件格式,
3,提取邮件的一些信息
以上的发件人发送时间主题等信息还可以如下表示
运行结果
a,收件箱等邮箱本身就存在的
b,如果是自己创建的文件夹及子文件夹
比如在我的邮箱中有自定义的文件夹 fo lders,如果要想获取其下面的子文件夹之一的相关资料则应如下书写4,用上面的方法提取出来的发件人是有公司名称的anotes CREATENAME(adocumentGETITEMVALUE("from")(0))ABBREVIATED
如果不使用abbreviated,则结果为
如果想要输出的发件人只有名字没有公司名的话可以做如下更改
结果为
排版之后的效果如下所示
以上代码是将发件箱中的附件保存到D盘的新建文件夹
racknerd怎么样?racknerd今天发布了几款美国特价独立服务器的促销,本次商家主推高配置的服务器,各个配置给的都比较高,有Intel和AMD两种,硬盘也有NVMe和SSD等多咱组合可以选择,机房目前有夏洛特、洛杉矶、犹他州可以选择,性价比很高,有需要独服的朋友可以看看。点击进入:racknerd官方网站RackNerd暑假独服促销:CPU:双E5-2680v3 (24核心,48线程)内存...
Virmach商家我们是不是比较熟悉?速度一般,但是人家价格低,而且机房是比较多的。早年的时候有帮助一个有做外贸也许需要多个机房且便宜服务商的时候接触到这个商家,有曾经帮助够买过上百台这样的低价机器。这里需要提醒的,便宜但是速度一般,尤其是中文业务速度确实不快,如果是外贸业务,那肯定是没有问题。这几天,我们有看到Virmach推出了夏季优惠促销,VPS首年8折,最低年付仅7.2美元,多机房可选,如...
hostsailor怎么样?hostsailor成立多年,是一家罗马尼亚主机商家,机房就设在罗马尼亚,具说商家对内容管理的还是比较宽松的,商家提供虚拟主机、VPS及独立服务器,今天收到商家推送的八月优惠,针对所有的产品都有相应的优惠,商家的VPS产品分为KVM和OpenVZ两种架构,OVZ的比较便宜,有这方面需要的朋友可以看看。点击进入:hostsailor商家官方网站HostSailor优惠活动...