如何通过Outlook 2007向多个电子邮件地址发送电子邮件 [英] How can I send an email to multiple email addresses through Outlook 2007
问题描述
嗨
我有一个名为Info的表,其中包含一个名为Email Address的列。我想在一个名为Customer的表单中创建一个命令按钮,它将Info表作为记录源,我希望此命令在Outlook 2007中打开一个新的电子邮件窗口,并将所有电子邮件地址复制到To字段而不会忘记每封电子邮件后添加分号
我该怎么办?或者这个按钮的VB代码是什么?
我在Access中不太好但我有一点经验
任何帮助都会很大赞赏
Hi
I have a table called Info with a column called Email Address in it. I want to create a command button in a form called Customer ,which has the Info table as the Record Source, and I want this command to open up a new email window in Outlook 2007 and copy all the email addresses to the To field without forgetting adding a semicolon after each email
How can I do that? or what is the VB code for such button?
I''m not so good in Access but I have a little experience
Any help will be greatly appreciated
推荐答案
@farisallil
首先,确保将参考设置为 Microsoft Outlook XX.X对象库。假设您有一个名为 tblEMailAddress 的表,并且它包含一个字段来保存名为 [电子邮件地址]的电子邮件地址:
@farisallil
First, make sure that you have a Reference set to the Microsoft Outlook XX.X Object Library. Assuming you have a Table named tblEMailAddress, and it contains a Field to hold the E-Mail Addresses named [EMail Address] :
PS - 要打开Outlook并且不自动发送,请替换。发送使用 .Display 。
P.S. - To Open Outlook and NOT Send automatically, replace .Send with .Display.
此代码不需要引用Outlook,如果您的应用程序可能存在,我建议您不要使用它一会儿。
This code does not require a reference to Outlook, and I would suggest not using one if there is a possibility of your application being around a while.
这篇关于如何通过Outlook 2007向多个电子邮件地址发送电子邮件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!