+ Reply to Thread
Results 1 to 3 of 3

Share Outlook macro as an Add-in?

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Chicago, IL
    MS-Off Ver
    Office 365
    Posts
    35

    Share Outlook macro as an Add-in?

    I'm pretty good at Excel macros & Addins -- not so much with Outlook (I don't even use that application for emails) BUT I did come up with a macro that works to save attachments to a specific folder. I want to share that with some co-workers.

    What I have in the vba "Project" window is called:
    vbaCSC_attachments(VbaProject.OTM) What are the next steps to get this same macro into other PCs? I don't even know where it's saved (and also instructions on how they would load that macro or Add-in.


    Outlook VBA Screenshot 2024-02-22 090735.jpg

    Thank you,
    Pat
    Last edited by patb; 02-22-2024 at 04:12 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Share Outlook macro as an Add-in?

    You can't create add-ins from VBA for Outlook the same way that you can for Excel. You would need to create it in a separate development environment in JavaScript using Yeoman generator for Office Add-ins, or in Visual Studio. I've never done that so I can't take that any further.

    One option is to export the Module as a .bas file then instruct people how to import it to the their Outlook project. It's not much harder than installing an add-in. Once they add the code, they would have to set up some way to trigger it, like a custom Ribbon button.

    It looks like you changed the name of your Outlook project from Project1. That's fine, but again, unlike Excel, you can only have one Outlook VBA project.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    Chicago, IL
    MS-Off Ver
    Office 365
    Posts
    35

    Re: Share Outlook macro as an Add-in?

    Thanks for the confirmation as that is what I was starting to do - I exported the .bas file and was going to try it out explaining it to a coworker/friend who would be more patient with my learn-by-doing instructions! I can then walk them through the process of putting a button on their ribbon like I did for mine.

    Again, thanks for letting me know that there are no Add-ins to be had in Outlook,
    Pat

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. share excel workbook with Outlook
    By gamlan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2019, 01:17 PM
  2. Macro to un-share then re-share OR spell check a hsared workbook Macro?
    By yetibeard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2018, 06:32 PM
  3. how to share a outlook userform with other outlook users
    By Megatronixs in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 01-02-2015, 03:48 PM
  4. Share macro through two different networks/ Share through Internet.
    By Saji P in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2013, 05:30 AM
  5. Share Task From Outlook 2010 to Outlook 2007 and Vice Versa
    By Hudas in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-22-2012, 03:01 PM
  6. [SOLVED] Need Help w/ getting my Excel 2010 spreadsheet to share information w/ Outlook
    By pmallory7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2012, 03:07 PM
  7. [SOLVED] How do I share excel contacts with outlook?
    By amcpherso in forum Excel General
    Replies: 1
    Last Post: 04-28-2006, 05:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1