Initiate Meeting Request using excel macro in outlook

Hi Team,

Need your expert help in creating a macro to send meeting request through outlook from excel. I don't know if this can be easily achieved through macro but below are the requirements:

1. Use excel fields to send meeting request in outlook .
2. In the body it should Change the names <<Ray>> and <<team1>> dynamically to its respective <<Name>> and <<Team Names>> fields.
3. Attachments can be multiple; however if no attachments are found in the location(c:/temp) or if attachment field in excel sheet is blank it should still continue to send the meeting requests.
4. The macro should be initiated from excel when we press ctrl+q key and should be appear as shown in the Result screenshot attached.

Thanks!

4gurus

Hi,

I think this is what you need. Sorry I owe you the bold text in the body .

Run the macro called :GenerateMeetingRequests

Main Code:

Please Login or Register  to view this content.

Sub to generate the meeting:

Please Login or Register  to view this content.

Other function and helper subs:

Please Login or Register  to view this content.

I hope this helps


excel-outlook macro.xlsm

Thanks

Hi Alfredo,

Fristly, thank you so much for writing the code. I downloaded the file you had attached (excel-outlook macro.xlsm) and ran the code Generatemeetingrequests while outlook 2007 was open but nothing happened.

Then I made sure I added those email address in address book and ran the macro again but nothing happens.

Let me know if I am doing anything wrong.

One more requirement, I don't know if you would be able to incorporate; that is if the email addresses listed in excel file are not present in outlook address book or global address book( it is an organization's exchange server) it should still continue to send meeting request based on what is present in the excel file.

It was great to see how you were able to send the meeting request by running the code. I don't know what I am missing here.

Thanks!

4Gurus

Hi Alfredo,

Fristly, thank you so much for writing the code. I downloaded the file you had attached (excel-outlook macro.xlsm) and ran the code Generatemeetingrequests while outlook 2007 was open but nothing happened.

Then I made sure I added those email address in address book and ran the macro again but nothing happens.

Let me know if I am doing anything wrong.

One more requirement, I don't know if you would be able to incorporate; that is if the email addresses listed in excel file are not present in outlook address book or global address book( it is an organization's exchange server) it should still continue to send meeting request based on what is present in the excel file.

It was great to see how you were able to send the meeting request by running the code. I don't know what I am missing here.

Thanks!

4Gurus

Replace this code for CreateMeetingRequest apparently the meeting has to be displayed for the recipients to show. I have also added code to highlight red the items that failed.

Thanks

Please Login or Register  to view this content.

Hi Alfredo,

This time when I ran the macro the meeting request did come up however quite a few things were missing and I have attached the screen shot and the file I used. Please have a look at it.

Things that were missing this time are:
Location, Subject, attachments(file1 and file2), and body of the message where as Start time and End time were different than what we have in the excel sheet


Thanks!

4Gurus

Hi Jaslake,

Thank you so much for being the macro savior; your recommendation worked.

Thanks!

4gurus

Ah no credit for me

Kidding I am happy this is solved

Hi Fredlo,

My bad; you definitely deserve the credit here. All of this would not have happened if you had not started it.

Once again kudos to both of you.

Thanks!

4gurus