This book explains how to leverage and automate Outlook functionality from Excel with Visual Basic for Applications (VBA). It contains numerous macro examples to send email from Excel, extract emails, download attachments, reply to or forward emails automatically, create mail rules, manage the calendar and send meeting invites, re-schedule multiple meetings, find calendar availability, extract meeting attendees, save contacts, assign tasks, and much more. See the full list of macros below.
Get it now for just $9.99
Delivery may take a few hours or land in your spam folder. Contact me if any issues: xlsgsdata@gmail.com
List of contents:
About
1. Introduction
1.1. Requirements for Excel-Outlook integration
1.2. Excel VBA vs Outlook VBA
1.3. Code conventions
2. Outlook Object Model
2.1. Application object
2.2. Explorer and Inspector
2.3. NameSpace object
2.4. Folder and Items
3. Profile and Accounts
3.1. Profile
3.2. Check if Outlook is open
3.3. Open/close Outlook
3.4. Accounts
3.5. Account Logon
4. Folders
4.1. Get Folder
4.2. Add Folder
4.3. Copy vs Move Folder
4.4. Delete Folder
5. Items
5.1. Get items
5.2. Item type
5.3. Count items
5.4. Create items
5.5. Copy vs Move items
5.6. Display items
5.7. Send items
5.8. Save items
5.9. Delete items
6. Mail
6.1. Send Mail
6.2. Get Mail
6.3. Reply and Forward Mail
6.4. Copy or Move Mail
6.5. Save and Delete Mail
7. Calendar
7.1. Appointment vs meeting
7.2. Create appointments
7.3. Send meeting invites
7.4. Get meeting requests
7.5. Calendar appointments
8. Contacts
8.1. Address book.
8.2. Add contacts
8.3. Contact group
8.4. Get contacts
8.5. Share and forward contacts
8.6. Move and delete contacts
9. Tasks
9.1. Tasks vs To-Do list
9.2. Create tasks
9.3. Assign tasks
9.4. Respond to task requests
9.5. Retrieve and update tasks
9.6. To-Do list items
APPENDIX A: List of macros
APPENDIX B: Outlook VBA Objects
APPENDIX C: Enumerations
Index
1. Introduction
1.1. Requirements for Excel-Outlook integration
1.2. Excel VBA vs Outlook VBA
1.3. Code conventions
2. Outlook Object Model
2.1. Application object
2.2. Explorer and Inspector
2.3. NameSpace object
2.4. Folder and Items
3. Profile and Accounts
3.1. Profile
3.2. Check if Outlook is open
3.3. Open/close Outlook
3.4. Accounts
3.5. Account Logon
4. Folders
4.1. Get Folder
4.2. Add Folder
4.3. Copy vs Move Folder
4.4. Delete Folder
5. Items
5.1. Get items
5.2. Item type
5.3. Count items
5.4. Create items
5.5. Copy vs Move items
5.6. Display items
5.7. Send items
5.8. Save items
5.9. Delete items
6. Mail
6.1. Send Mail
6.2. Get Mail
6.3. Reply and Forward Mail
6.4. Copy or Move Mail
6.5. Save and Delete Mail
7. Calendar
7.1. Appointment vs meeting
7.2. Create appointments
7.3. Send meeting invites
7.4. Get meeting requests
7.5. Calendar appointments
8. Contacts
8.1. Address book.
8.2. Add contacts
8.3. Contact group
8.4. Get contacts
8.5. Share and forward contacts
8.6. Move and delete contacts
9. Tasks
9.1. Tasks vs To-Do list
9.2. Create tasks
9.3. Assign tasks
9.4. Respond to task requests
9.5. Retrieve and update tasks
9.6. To-Do list items
APPENDIX A: List of macros
APPENDIX B: Outlook VBA Objects
APPENDIX C: Enumerations
Index
List of Macros:
Minimize (or close) explorer windows
Close all inspector windows
Check if Outlook is open
Open/close Outlook
List profile accounts
Add new folder
Copy/move existing folder
Delete folder
List items in folder
Count items in folder
Create new item
Add item to folder
Copy/move items in folder
Save item to computer
Delete items in folder
Create new email
Create email from template
Send email to various recipients
Send email with formatted body
Send email with hyperlink, picture or table
Send email with signature
Send email with attachments
Send email with priority, readreceipt, or task
Send email from another account
Send email deferred delivery
Send multiple emails
Extract email information
Extract multiple emails
Extract unread emails
Extract emails received within timeframe
Extract emails with keyword in subject or body
Download email attachments
Mark emails as read or unread
Add/remove flags to/from emails
Categorize emails in folder
Create new email rule
Reply/forward emails in folder
Copy/move emails in folder
Save email to computer
Save email as PDF
Delete emails in folder
Create new calendar appointment
Create multiple appointments
Send meeting invitation
Extract meeting information
Accept/decline meeting request
Extract appointments from default calendar
Extract appointments from another calendar
Extract meeting responses
Find calendar availability
Copy/move appointments in calendar
Cancel/delete appointments in calendar
List address books in profile
List entries in address book
Add another address book
Add contact to address book
Add multiple contacts to address book
Add contact group to profile
Extract contact information
Update contact information
Extract contact information from GAL
Send contact business card
Save contacts to computer
Move or delete contacts
Create new task
Add multiple tasks
Mark email as task
Assign task to recipient
Respond to task request
Extract task information
Update task information
Send task status report
Move or delete tasks
Loop through flags in To-Do list
Extend date of overdue email flags
Remove all email flags
Close all inspector windows
Check if Outlook is open
Open/close Outlook
List profile accounts
Add new folder
Copy/move existing folder
Delete folder
List items in folder
Count items in folder
Create new item
Add item to folder
Copy/move items in folder
Save item to computer
Delete items in folder
Create new email
Create email from template
Send email to various recipients
Send email with formatted body
Send email with hyperlink, picture or table
Send email with signature
Send email with attachments
Send email with priority, readreceipt, or task
Send email from another account
Send email deferred delivery
Send multiple emails
Extract email information
Extract multiple emails
Extract unread emails
Extract emails received within timeframe
Extract emails with keyword in subject or body
Download email attachments
Mark emails as read or unread
Add/remove flags to/from emails
Categorize emails in folder
Create new email rule
Reply/forward emails in folder
Copy/move emails in folder
Save email to computer
Save email as PDF
Delete emails in folder
Create new calendar appointment
Create multiple appointments
Send meeting invitation
Extract meeting information
Accept/decline meeting request
Extract appointments from default calendar
Extract appointments from another calendar
Extract meeting responses
Find calendar availability
Copy/move appointments in calendar
Cancel/delete appointments in calendar
List address books in profile
List entries in address book
Add another address book
Add contact to address book
Add multiple contacts to address book
Add contact group to profile
Extract contact information
Update contact information
Extract contact information from GAL
Send contact business card
Save contacts to computer
Move or delete contacts
Create new task
Add multiple tasks
Mark email as task
Assign task to recipient
Respond to task request
Extract task information
Update task information
Send task status report
Move or delete tasks
Loop through flags in To-Do list
Extend date of overdue email flags
Remove all email flags
Other Information:
Presentation: eBook (digital copy)
Format: PDF
Size: 4,774 KB
Created by (author): Excel Macro Mania
Created in (year): 2024
Number of pages: 165
Language: English
No comments:
Post a Comment