Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2021, 06:39 AM
bjornltd bjornltd is offline Making a Outlook macro that opens a Excel Workbook Windows 10 Making a Outlook macro that opens a Excel Workbook Office 2016
Novice
Making a Outlook macro that opens a Excel Workbook
 
Join Date: Jul 2021
Posts: 1
bjornltd is on a distinguished road
Default Making a Outlook macro that opens a Excel Workbook

Hi,

I am new to VBA and trying to make a tedious task a bit easier. Hopefully someone can help me with this.

I have 3 different users in 3 different locations that handle my Outlook Calendar. They fill out appointments with customers, they also make an Excel file for that customer.
I have made some quick share form (enclosed image), that they fill relevant information, but not the macro button.

What I want to do, is to make their job a bit easier by making a macro in Outlook Calendar that does (by pressing a button):

1.
Opens a specific Excel Workbook in a shared location, but it’s not the same path on each computer. It is shared in a group area of Onedrive.

2.
Takes specific fields from the Outlook appointment and copies it to specific cells in the Excel Workbook. (image enclosed)

• #1 – Copy to cell B34
• #2 – Copy to cell B35
• #3 – Copy to cell B36
• #4 – Copy to cell B37
• #5 – Copy to cell B38, but only the date in format DD.MM.YY

3.
Runs a VBA (called: SvMe) in the open Excel Workbook and closes the workbook.
This will result in a Excel Workbook for that customer, that I will use later.



Hope someone can help me with this. It would save a whole lot of time for the girls in the departments.

Thank you
Attached Images
File Type: png screenshot.PNG (46.3 KB, 10 views)
Reply With Quote
Reply

Tags
excel 2016, outlook 2016, vba code

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook Opens Slow from File Explorer RetiredCHE Excel 0 08-18-2017 12:13 PM
Macro Personal Workbook does not load in Excel 2016 Intruder Excel Programming 0 01-21-2017 05:44 AM
Hyperlink in excel opens email...can a macro fill in and insert attachments? Tammypi Outlook 1 09-16-2014 10:36 PM
Making a Outlook macro that opens a Excel Workbook Run Code when Workbook opens gbaker Excel Programming 2 07-10-2012 10:41 AM
the saveas macro in excel 2010 is not transferring the macros to the new workbook missmr28 Excel Programming 3 06-20-2012 05:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft