Linking Dates in Excel to Outlook Calendar

  • Thread starter Thread starter Frangle
  • Start date Start date
F

Frangle

I have a spreadsheet which contains expiry dates. I would like to know if
there's a way of linking the dates directly into Outlook without having to
manually insert the dates in Outlook as there are quite a lot of them and
they will be subject to change.

If VBA is the only answer, please provide dummy instructions as I am by no
means an expert with VBA.

Many thanks in advance.
 
Dear Diane

I was hoping to link rather than import otherwise I will have to import
again if the info changes which is likely. Any vba code to help the linking
would be appreciated.

Many thanks anyway for a very fast response.
Regards



Diane Poremsky said:
Linking in what way? You could import them into outlook as appointments.
http://www.slipstick.com/Tutorials/import/import.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Frangle said:
I have a spreadsheet which contains expiry dates. I would like to know if
there's a way of linking the dates directly into Outlook without having to
manually insert the dates in Outlook as there are quite a lot of them and
they will be subject to change.

If VBA is the only answer, please provide dummy instructions as I am by no
means an expert with VBA.

Many thanks in advance.
Click to expand...
Click to expand...
 
I'm not aware of any ready to use code offhand - try outlookcode.com and
excel vba websites. You would use ODBC to make the connection.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Frangle said:
Dear Diane

I was hoping to link rather than import otherwise I will have to import
again if the info changes which is likely. Any vba code to help the
linking
would be appreciated.

Many thanks anyway for a very fast response.
Regards



Diane Poremsky said:
Linking in what way? You could import them into outlook as appointments.
http://www.slipstick.com/Tutorials/import/import.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point
your
newsreader to msnews.microsoft.com.


Frangle said:
I have a spreadsheet which contains expiry dates. I would like to know
if
there's a way of linking the dates directly into Outlook without having
to
manually insert the dates in Outlook as there are quite a lot of them
and
they will be subject to change.

If VBA is the only answer, please provide dummy instructions as I am by
no
means an expert with VBA.

Many thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top