Amanda has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course
Excel Dashboards for Business Intelligence course
Managing Upwards course
Outlook
Anyone know how to write a macro for excel that will work with outlook to populate a meeting request, subject line & all for a day or date range within the data?
RE: Outlook
Hi Amanda,
Thank you for the forum question.
To control Outlook from Excel you need to reference the Outlook object library. You will need to work with Object variables and more.
I have added a couple of links below with some examples but may I suggest that you do our Intermediate Course and then our advance VBA course. On our advanced VBA course we are controlling Outlook from Excel using the reference library.
http://www.pcreview.co.uk/threads/re-create-a-meeting-request-using-vba.1836614/
http://www.mrexcel.com/forum/excel-questions/500849-sending-meeting-requests-through-outlook-using-excel-macro.html
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
