Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Dates from Excel to Outlook


  • Please log in to reply

#1
calvert27

calvert27

    New Member

  • Member
  • Pip
  • 1 posts
I am creating a spreadsheet of activities that need to be completed on certain dates. What my boss wants is for those dates in Excel to pop up on the Outlook calendar when Outlook is opened.

Obviously I know how to put dates into Outlook, but I'm not sure how to link Excel and Outlook without exporting data all the time.

The spreadsheet layout is as such:
Column A: Activity
Column B: Commencement Date
Column C: Days to Complete
Column D: End Date
Column E: Assigned To

D is the key/schedule date here... I also want A and E to be displayed...

I've seen a few VBA codes but being rather inexperienced in this area I seem to be missing the first few steps... If anyone can help, please do! But please keep it nice and simple and start from scratch :)

Thanks!
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
I've no experience of this myself but maybe this will help?

http://forums.techgu...to-outlook.html
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP