Paste to Outlook Calendar

[Slayboy]

Really Simple Question (you'd think!)

Hi,

I've got some code on a form that creates an appointment item, copies it and then opens a program (an Outlook Calendar), then the problem comes. I need to run the paste command in the calendar window, I tried:

DoCmd.RunCommand acCmdPaste

But that just tries to paste into the database! Can anyone help me out with this, I'm convinced that it's just one little line of code like involving Ctrl+V or something, I've searched the forums and even looked on the internet for a batch file code that might do it but no joy.

Please can someone help me, thanks.

 

[Kodo]

I don't believe it's that simple. I'm pretty sure you have to actually open up the pst file in code and add a calendar item that way.

http://www.access-programmers.co.uk/forums/showthread.php?t=60999&highlight=outlook+calendar

 

[Slayboy]

That's what I want to do

Hi,

I would like to do that as the calendar is in a personal .pst file, but the code in that link that you gave only specifies mailboxes.

I tried loads of different ways to do this and the way I described has brought me the closest so far, if I can just work out how to run a paste function in an external program to Access it will work. You see so far I get it to open the calendar and then if I go to Edit - Paste (or type Ctrl+V) then it pastes the appointment so I just need to automate that.

 

[Kodo]

that's an unconventional way of doing it and may not work 100% of the time and such would advise against it as your application environment and user intervention may cause it to fail.

http://www.access-programmers.co.uk/forums/showthread.php?t=31517&highlight=access+outlook+calendar

 

[Slayboy]

That code won't help either

Hi,

The code on that link won't really help me either, it just saves to the default calendar.

I really think unless someone knows how to set the appointment in a personal folder, that my paste idea is the only way to go.

Can I ask again if anyone knows how to write code in access VBA to run a paste command in an external program?

 

[Kodo]

can you better explain your environment then? because that second link I posted does what you want to do. It adds an appointment to the calendar, the proper way..

 

[Slayboy]

Just need an external paste function

Hi,

What I've got is a personal folder in my outlook called 001LeaveCal, which contains a calendar called 001LeaveCalendar. I've tried lots of codes which try to use the pathname "001LeaveCal\001LeaveCalendar", split them etc but none of the code works, it never recognises personal folders, only mailboxes.

But basically I just want a paste function (it doesn't have to be anything to do with outlook, it just needs to work the same as pressing Ctrl+V on an external program but run from access VBA)