Excel VBA Introduction Part 29.9 - Finding Outlook Emails using Filters
21.9 هزار بار بازدید -
5 سال پیش
-
By Andrew Gould
By Andrew Gould
https://www.wiseowl.co.uk - in this video you'll learn how to use the Find method and filters in Outlook to search for an email by sender name and subject. You'll learn how to retrieve a list of items from the Outlook inbox, how to apply the Find method to the Items collection and how to construct a filter string to get a reference to a single item in the collection. You'll also learn of a potential issue with the subject of replies and forwarded messages as well as how to deal with the problem. Finally, you'll learn how to copy the body of an email into an embedded Word document in an Excel worksheet.
You can download the completed file here https://www.wiseowl.co.uk/vba-macros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here http://www.lulu.com/shop/andrew-gould...
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
https://www.wiseowl.co.uk - in this video you'll learn how to use the Find method and filters in Outlook to search for an email by sender name and subject. You'll learn how to retrieve a list of items from the Outlook inbox, how to apply the Find method to the Items collection and how to construct a filter string to get a reference to a single item in the collection. You'll also learn of a potential issue with the subject of replies and forwarded messages as well as how to deal with the problem. Finally, you'll learn how to copy the body of an email into an embedded Word document in an Excel worksheet.
You can download the completed file here https://www.wiseowl.co.uk/vba-macros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here http://www.lulu.com/shop/andrew-gould...
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
5 سال پیش
در تاریخ 1398/02/06 منتشر شده
است.
21,905
بـار بازدید شده