|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-connecting-outlook-application/
课程评论：没有评论
课程名称：Excel VBA 连接 Outlook 应用程序 - 超高级 课程概述：本课程将教您如何使用 Excel VBA 连接 Outlook。我们将探讨早期绑定和后期绑定两种方法的优缺点，学习发送自动邮件、定制邮件主题、正文、签名、收件人、抄送、密件抄送及附件的技巧。此外，还将介绍如何在 Outlook 中复制或移动文件夹，以及如何在不同文件夹之间移动电子邮件。 您将学习如何从 Outlook 邮件中提取文件并保存到本地计算机，如何处理默认文件夹和自定义的文件夹/子文件夹，以及如何使用文件对话框选择用户想要的文件夹。在邮件正文中以快照形式发送数据也是课程的一部分。本课程覆盖了所有与 Outlook 应用程序相关的自动化内容，适用于希望实现各类自动化任务的学生。 课程中将有多个项目实例，如如何设置会议日历、回复客户独特请求的编号、从 Outlook 邮件正文中提取手机号码及其他信息并导出到 Excel 单元格、使用超链接、发送电子邮件并在 Excel 中更新状态等。此外，您还可以学习如何在邮件中使用快照、HTML 标签、粗体文本和添加您喜欢的logo等。 课程还将比较早期绑定和后期绑定的利弊，并教您如何在 Outlook VBA 编辑器中以谨慎方式编写 Excel VBA 代码。您在学习过程中提出的问题将在 48 小时内得到解答，我们将始终提供支持和帮助。
We are learning how to connect Outlook with Excel VBA.Early binding approach and Late Binding Approaches. Advantage/DisadvantagesSending auto emails, Customizing the email subject lines, body , signatures , to , cc, bcc ,attachmentsCopying or moving folders in outlookCopying or moving emails from one folder to anotherHow to extract the files from outlook emails and save them on your machine.How to work with default folders, own created folders/subfoldersHow to use file dialogs in emails giving choice to select whichever folder user want to choose.How to send data as a snapshot in outlook bodyThere are so many things - anything which you think is a part of outlook application and you would like to automate it - can be done.Multiple projects for you coming from students directlyFor eg. how to set up meeting calendarsHow to reply to clients with some unique request numberHow to extract the mobile number and other information from body of outlook and export it all in excel cells,How to use hyperlinksHow to send emails and update their status as done in excelHow to handle email addresses, body content, subject lines for outlook using excel sheets.How to send emails with snapshotsHow to use html tags and provide content bolder and also choose images if you want to send in body of an email.Many personal projects for your confidence and exposure for eg. how to send formatted email using ms word. How to bold texts and attach logos , any logo that you like to use.Early binding and late binding - Advantages and Disadvantages of both approaches.Learn outlook VBA as well. In section 2, You will see how to write same excel vba codes with little caution on outlook vba editor.Your questions will be answered with in 48 hours. Always there to assist you.
