Macro to Automate Notices in Outlook Calendar

[Emily]

Let me start out by saying that I've never used a macro before. I've printed
some basic "how to" info from Microsoft's web site, but have yet to create or
use one.

I am looking to create a macro to automate data from an Access file to place
a note on an Outlook calendar. More specifically, we want it to calculate 30
days, 60 days, 90 days and 150 days beyond a specified date in Access and
carry a note accordingly to the Outlook calendar.

Any ideas on how to set this up or suggestions? Specific instructions would
be most helpful. Thanks!

 

[Steve Schapel]

Emily,

I don't think a macro is a suitable approach here. I suggest you might
re-post your question to the externaldata newsgroup - you will heve a better
chance of a good answer there.

 

[Emily]

Thank you for your response. I am new to this community newsgroup. Where
can I find the externaldata newsgroup? I didn't see it in the sidebar menu.

On another note, do macros within Access work within the Microsoft family
(connecting data to other Microsoft products outside of Access)?

Thank you for your help.

 

[Steve Schapel]

Emily,

No, you wouldn't normally use Access macros to relate with data in other
applications.

In some cases, you can Link to data in other applications, and then this
data is treated within Access just as if it was in local tables.

In other cases, you can use VBA procedures, employing Office Automation
code, to interact with and manipulate data in other applications.

The newsgroup I mentioned is referred to in the sidebar as 'Importing and
Exporting'.

 

[Emily]

Thank you very much for your help Steve.