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.
 
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.
Similar threads
Thread starter Title 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
L When scheduling a meeting - everyone else's calendar has "hash" ma Using Outlook 3
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 10
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
P OT: Need website like this one, but for Excel Using Outlook 0
S Need code to allow defined starting folder and selection from there to drill down Outlook VBA and Custom Forms 10
D Need help with MS Authenticator Using Outlook 4
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S.Champ Please help? I've imported a random workcalendar I dont even know who's. Can I undo it? and then I need to re-sync the google one again. Its a mess:( Using Outlook 2
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
D Do I need Exchange Add-In? Using Outlook 6
L Need help modifying a VBA script for emails stuck in Outbox Outlook VBA and Custom Forms 6
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
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
E 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

Similar threads

Back
Top