convert VBA code to Add-in

Status
Not open for further replies.
B

bWFzYW5pIHBhcmVzaA

Hi,

I have written simple VBA macro to delete recurrence meetings in

outlook(macro cod is given below). Could any one please tell me what is the

simplest method to convert this macro into Outlook Add-in such that it should

create button on Outlook toolbar and also register itself and start working.

Sub DeleteMeetings()

Dim olkItems As Outlook.Items

Set olkItems = Session.GetDefaultFolder(olFolderCalendar).Items

olkItems.IncludeRecurrences = True

For Each olkAppt In olkItems

olkAppt.Delete

Next

Set olkItems = Nothing

MsgBox "Macro executed successfuly: " & Err

End Sub

Thanks,

Paresh
 
Using what development platform, language and Outlook version?

There is no VBA to addin converter, you first start with whatever platform

and language you want and set up a skeleton addin, then copy in your VBA

code and if necessary translate it into the language you're using.

If you intend to use managed code you will need to somehow shim your addin

so it has its own AppDomain, either using VATO or the COM shim wizard. If

using VB.NET you need to translate the code since VB.NET has many

differences from VBA code (for one thing Long is 64-bit and Integer is

32-bit). VB6 code is much closer to VBA code.

You then need to register your addin and deploy it as well as any

dependencies and prerequisites, such as the Framework for managed code.

"masani paresh" <masanip@deshaw.com> wrote in message

news:8C2E171E-4957-4801-9251-A0E6B3BD924C@microsoft.com...
> Hi,

> I have written simple VBA macro to delete recurrence meetings in
> outlook(macro cod is given below). Could any one please tell me what is
> the
> simplest method to convert this macro into Outlook Add-in such that it
> should
> create button on Outlook toolbar and also register itself and start
> working.

> Sub DeleteMeetings()

> Dim olkItems As Outlook.Items
> Set olkItems = Session.GetDefaultFolder(olFolderCalendar).Items
> olkItems.IncludeRecurrences = True

> For Each olkAppt In olkItems
> olkAppt.Delete
> Next

> Set olkItems = Nothing

> MsgBox "Macro executed successfuly: " & Err

> End Sub

> > Thanks,
> Paresh
 
Status
Not open for further replies.
< Outlook 2007 Add-in Bug with with Exchange - Long explanation | get the total unread mails >
Similar threads
Thread starter Title Forum Replies Date
Z VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
Q How tough is it to convert VBA to Addin Outlook VBA and Custom Forms 1
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
T Why does outlook 2010 convert only some forum notifications to plain text? Using Outlook 0
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
P How do I convert outlook “to-do” items to “tasks” Outlook VBA and Custom Forms 1
I Convert POP3 account (PST) to IMAP (.OST) Using Outlook 3
S problem with convert Using Outlook 1
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
C convert an .ost to .pst Using Outlook 3
D The way to convert ost to pst Using Outlook 2
J Outlook 2013 how to convert 2013 OST file into an another format, i m using outlook 2013 versions. Using Outlook 1
sneaky30 convert text to date Outlook VBA and Custom Forms 1
P Is it possible to convert address book to "Auto-Complete List" (NK2)? Using Outlook 5
Diane Poremsky Convert an Offline File (.ost) to a Personal File (.pst) Using Outlook 0
S How to do I convert OST file to PST? Exchange Server Administration 3
J convert .pst to .eml, how is it possible? Using Outlook 1
M convert/import a customized record into the default "Account" record BCM (Business Contact Manager) 0
V Check/convert to emailaddresses Outlook VBA and Custom Forms 11
R Convert Access table to pst Using Outlook 1
M Outlook 2013 won't convert Excel contacts into Outlook contacts using my custom form Using Outlook 3
L Convert Distribution List of Contacts to Single Contacts Using Outlook 6
G Is there any way to convert outlook 2003 to outlook 2007 Using Outlook 5
D Outlook contacts no in address book - 2002 pst file convert to 2007 pst file? Using Outlook 0
P Outlook 2002 - How to upgrade to 2003 and convert PST from ANSI to Unicode? Using Outlook 7
A Outlook 2003: convert all RTF emails to HTML Outlook VBA and Custom Forms 1
J How to convert BCM contacts to normal Outlook contacts BUT... BCM (Business Contact Manager) 2
G Tasks - convert email to task & attach email Outlook VBA and Custom Forms 6
A Re: Convert Oportunity to Project? BCM (Business Contact Manager) 3
L VBA to Triage Incoming Email Outlook VBA and Custom Forms 0
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 2
H using VBA to edit subject line Outlook VBA and Custom Forms 0
G Get current open draft message body from VBA Outlook VBA and Custom Forms 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
R Outlook 365 VBA AUTO SEND WITH DELAY FOR EACH EMAIL Outlook VBA and Custom Forms 0
R Outlook 2019 VBA to List Meetings in Rooms Outlook VBA and Custom Forms 0
geoffnoakes Counting and/or listing fired reminders via VBA Using Outlook 1
O VBA - Regex - remove double line spacing Outlook VBA and Custom Forms 1
D.Moore Strange VBA error Outlook VBA and Custom Forms 4
B Modify VBA to create a RULE to block multiple messages Outlook VBA and Custom Forms 0
D Outlook 2021 Using vba code to delete all my spamfolders not only the default one. Outlook VBA and Custom Forms 0
K vba code to auto download email into a specific folder in local hard disk as and when any new email arrives in Inbox/subfolder Outlook VBA and Custom Forms 0
D VBA - unable to set rule condition 'on this computer only' Outlook VBA and Custom Forms 5
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1

Similar threads

Back
Top