Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>>

Status
Not open for further replies.

Denis

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi All,

I need some help or a point in the right direction in regards to setting up a particular spread sheet to automate appointments into my Outlook Calendar? I have the following headings and I need to have these auto fill when I enter data into the corresponding cells. Is there a macro or the like that I can create to link the Excel spread sheet data and have it log it into a calendar for me. At the moment I am testing it in an Office 2007 environment however if it works ok I would like to try and implement this into a Exchange environment.

REFERENCE MATTER DATE TIME CLIENT NAME TRANSACTION TYPE VENUE

Thank you to anyone who is able to help me in any way as I am in way over my head and I am desperately trying to help out somebody else!!!!

Thanks Again.....
Denis.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You should be able to use a macro to create an appointment when you do something in Excel - this Excel macro imports the entire spreadsheet into outlook - http://www.slipstick.com/developer/create-appointments-spreadsheet-data/ - there should be some macros floating around that show how to trigger a macro when you tab out of a cell or enter a value in a cell - you'll also need to grab the correct row and pass it to the macro. Remove the do until & loop lines and it should work.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Create Exchange Rule for everyone that highlights an email based on content of subject Exchange Server Administration 1
microsvc Populating everyone's calendar with campus events Exchange Server Administration 1
C Exchange 2010-Allow mailbox "Send As" permissions for Everyone. Exchange Server Administration 3
S Update Rollup 2 for SP1 - how is everyone doing? Exchange Server Administration 5
R Let Everyone View Equipment Calendar Using Outlook 1
A everyone has access to any mailbox, how can i remove this? Exchange Server Administration 11
M Cannot make new view visible to everyone in Outlook 2007 Using Outlook 2
D I'm trying to set up a contact list that everyone in the office has access to. We are on a network. Using Outlook 2
L When scheduling a meeting - everyone else's calendar has "hash" ma Using Outlook 3
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 14
A Wishlist Arthur workman I need the community's assistance thank you Using Outlook 3
A from Arthur to anyone I need your expertise assistance Using Outlook.com accounts in Outlook 7
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
T Need to backup outlook.com to cloud storage, without desktop software - Testing UpSafe. Are there any similar services? Using Outlook.com accounts in Outlook 8
C need help setting up outlook first time Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
L Need to import multiple Outlook files to Office 365 Account Using Outlook 4
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
EaglePI Outlook 2010 need help with rules Using Outlook 0
Horsepower Need iCloud mail only Using Outlook 1
O Don't need any add-ins at all? Using Outlook 2
B Need Help - Willing to pay Outlook VBA and Custom Forms 10
A Need to view Outlook calendar in Sharepoint .. Using Outlook 2
J Need Help with Contacts VBA Outlook VBA and Custom Forms 1
L Accidentally merged a calendar with .ics, need to undo! Using Outlook 1
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
D Need Genuine Office or Outlook 2007 Using Outlook 3
G how to cancel a recurring meeting but not the organizer but all attendees need to know. Using Outlook 1
H I need a developer to customize an Outlook Contact form Outlook VBA and Custom Forms 0
T Need help with finding/updating task Outlook VBA and Custom Forms 1
N Need a case sensitive rule Outlook VBA and Custom Forms 1
C Need rule to alert when an email has not been replied to within 24 hours Using Outlook 1
P Outlook 2003 - Do I need a new profile? Using Outlook 2
F Outbox - Multiple Emails need to be manually opened? Using Outlook 5
Miquela I need to make a calendar to share here at work with 40 other people Using Outlook 1
S Need CC: to show the original To: recip[ients Using Outlook 4
D Need to extract a line from a word attachment, and add it to the subject line Outlook VBA and Custom Forms 3
Mary B VBscript: Need to copy every email to a folder & mark that copy as read Outlook VBA and Custom Forms 5
mikecox Desperat; need hands on support Using Outlook 1
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
Glyn Do I Need Outlook.com Using Outlook 1
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
G Need help configuring a PRF for Outlook 2010 and 2013 Using Outlook 0
K Excel Import Option: Need Help Updating Existing Records BCM (Business Contact Manager) 0
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
Stig Arvidsson Need a Script for handling moved mail from inbox Using Outlook 3
C Outlook 2010, Need to restrict domain users from installing any sort of a addin in outlook Using Outlook 2
J Need help with installation of BCM in Outlook2013 BCM (Business Contact Manager) 5
Similar threads


















































Top