Sending invite through Outlook 2007 via excel macro or VBA

**kartikeyadawar** · 03-05-2015, 03:07 AM

Hi Guys,

I have a data attaching below, suppose i have 20 employee in one dept i want something from which i can select one dept and send them all invite for the start time.
I want to send them an outlook invite subject as code.

Please help me prepare something which can be useful. by adding some buttons or something where i can just send them all invites for a particular date in one dept.
Outlook 2007 installed.
Meeting Invite Data.xlsx

Let me know if u have any questions. Thanks alot in advance

**Vikas_Gautam** · 03-05-2015, 05:30 AM

You may be interested in this:-
Sending Mail Automatically via Excel VBA

**rajuganapathy** · 03-05-2015, 05:51 AM

Hi Vikas,

it showing the error message the below mentioned line

With ActiveSheet.MailEnvelope

Thanks
Raju

**Vikas_Gautam** · 03-05-2015, 06:11 AM

Its working fine for me.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**rajuganapathy** · 03-05-2015, 08:48 AM

Hi Vikas,

Check,

Thanks
Raju

**Vikas_Gautam** · 03-05-2015, 09:41 AM

At my end code is working.
Here is the snapshot.

Code is working.PNG

**kartikeyadawar** · 03-05-2015, 05:32 PM

Hi Vikas,

Im too new for all VBA coding sorry for that.
I would paste the coding on a excel file rite..? and then run

Also what all colums would i need to add on the sheet. I did attached a sheet in my first post i will have data in that format.
I would have many people in one dept and would send them all an meeting invite not email for the start time at one go.

Please help me on this , this would really mean alot if u could attach a excel file with the coding according to the tabs i mentioned on the sheet.
Thanks alot in advance Vikas.Meeting Invite Data.xlsx

**kartikeyadawar** · 03-07-2015, 05:45 AM

Guys please help me on this..

**Vikas_Gautam** · 03-07-2015, 08:48 AM

Okay Kartik,
Can you tell me how should i refer following variables ?
I mean, Is it from sheet itself or some Separate text.

.MeetingStatus = olMeeting
.Subject = " Wedding Reception - Ramya & Mohan "
.Location = " PJN Mahal, #10, Egabaram Salai, Udaya Nagar, Porur, Chennai 116 "
.Start = "28-12-2013 07:00 PM"
.Duration = 150
.Body = strBody

**kartikeyadawar** · 03-08-2015, 06:22 AM

Meeting Invite Data 1.xlsx

I have attached a new sheet with the details to be mentioned on the invite.
the data will on a excel sheet.

Body can be empty.
Thanks

**Vikas_Gautam** · 03-09-2015, 05:07 PM

First make reference to the Microsoft Outlook xx.xx Library in the VBA window ---> Tools menu --> References option.
then use following code:-

HTML Code:

Code is working for me.
Remember to start ms outlook before using the above code.

**Vikas_Gautam** · 03-10-2015, 04:42 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**kartikeyadawar** · 03-10-2015, 06:03 AM

Will do. Thanks again for the help.

Really appreciate it.

Sending invite through Outlook 2007 via excel macro or VBA

LinkBack

Thread Tools

Rate This Thread

Display

Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Re: Sending invite through Outlook 2007 via excel macro or VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)

Macro for sending filtered data to multiple recipents (excel/outlook 2007)

Sending emails via outlook when a value in excel 2007 is changed

[SOLVED] Excel macro's deleted when sending through Outlook

Bookmarks

Bookmarks

Posting Permissions