MS Access2000 2-way communication with MS Outlook

[alanpike]

Using SendObject in an Access2000 macro, I can send a report as an email attachment to MS Outlook. I would like the capability to have the person reading the attached email report to somehow communicate (from the open outlook message...a button or something) their approval or rejection of the email which initiates another macro in Access2000. Is this possible and if so, where can I find some info concerning this type of automation?

[nico5038]

The mailed report will be in the .snp (snap) format and can be read by the recepient by using the Reader Microsoft offers for free at their site.
See:
http://www.microsoft.com/downloads/d...DisplayLang=en

A response is however not possible without coding or you need to wait for Access 2007 that will allow forms with data to be exchanged and added to a database table.

Nic;o)

[alanpike]

Thank you for your prompt response. It is greatly appreciated. Guess I'll need to find another way to do this. Thanks again.

[NeoPa]

You may be able to set something up using Application Automation of Outlook, but I'm afraid I can't help you with that, other than the basics.

[pks00]

What do u want to happen if they accept or reject the email?
What does the macro do
What u could do is either run updates yourself or run specific macros depending on what they select

eg - updating access table yourself from outlook - an example can be found here
http://www.thescripts.com/forum/thread630337.html

to run a macro, u could try this

Dim acc As Object

Set acc = CreateObject("A ccess.Applicati on")
acc.OpenCurrent Database ("C:\TSDN\mysex ybeast.mdb")
acc.DoCmd.RunMa cro "Macro1"
acc.CloseCurren tDatabase
Set acc = Nothing

[alanpike]

Thanks for the reply... this sounds promising. Can this code be initiated from outlook? Maybe a button or something that the user could initiate the event from within the email message? If so, any suggestion would be appreciated.

############### ############### ############### ########

What do u want to happen if they accept or reject the email?
What does the macro do
What u could do is either run updates yourself or run specific macros depending on what they select

eg - updating access table yourself from outlook - an example can be found here
http://www.thescripts. com/forum/thread630337.ht ml

to run a macro, u could try this

Dim acc As Object

Set acc = CreateObject("A ccess.Applicati on")
acc.OpenCurrent Database ("C:\TSDN\mysex ybeast.mdb")
acc.DoCmd.RunMa cro "Macro1"
acc.CloseCurren tDatabase
Set acc = Nothing

[pks00]

Only way I can think of for you to run code is via customising toolbar

so create a public sub in outlook vba

public sub Ouch2
'my code
msgbox "Updated"
end sub


Now open up a mail message, right click on toolbar, go down to macros, u should see on your right handside <<projectname>> .ThisOutlookSes sion.Ouch2
u drag this to your menu bar

and thats it. Now when u open a mail message u should see that, click on that and it should run your vba code