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
 
K

Ken Slovak - [MVP - Outlook]

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.
Similar threads
Thread starter Title Forum Replies Date
B 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
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) New Slipstick.com Articles 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
K Outlook Contact Group - can you convert to a .vcf? Using Outlook 1
P How can I convert an Outlook 2010 folder to a .pdf with active links like I could in Outlook 2007? Using Outlook 3
J Is it possible to convert a shared calender in Outlook to a ical version that can be subscribed to by confluence. Using Outlook 1
O convert OE Address book folders/subgroups to Outlook 2010? Using Outlook 4
O convert Outlook Express to Outlook 2010 Using Outlook 1
C convert windows live mail to outlook 2010 Using Outlook 4
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
A Convert client Outlook 2007 .ost to Outlook 2007 .pst Using Outlook 8
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
V Modifying the built in forms with VBA Outlook VBA and Custom Forms 4
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 4
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
L VBA unknown character Outlook VBA and Custom Forms 2
G Move tasks up/down todo list by VBA Outlook VBA and Custom Forms 1
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
K Use VBA to find Sender and Recipient from Microsfot 365 Journaled Email Items Outlook VBA and Custom Forms 3
J Want to learn VBA Macros for Outlook. What book can you recommend? Outlook VBA and Custom Forms 2
F VBA code to dock Styles whenever I write or edit an email Outlook VBA and Custom Forms 0
C VBA to prompt for Sent folder destination Outlook VBA and Custom Forms 3
B Adding signature to bottom of VBA reply email Outlook VBA and Custom Forms 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
D.Moore VBA script fail after Office 365 update Using Outlook 8

Similar threads

Top