DBinPhilly
04-22-2009, 08:01 AM
In a payroll application:
for employees who are getting direct deposit checks we want to email a copy of their check stub to them (formerly we snail-mailed them).
In VBA, I cycle through a list of the direct deposit recipients, and email each one using SendObject.
my problem: works perfectly in Windows 2000/Access 2000
in Windows XP/Access 2003, asks if I really want to do it for each employee
in Windows VISTA/Access 2003: doesn't work at all; get the following error message:
____(application name)____ CAN'T OPEN THE EMAIL SESSION
the command I am using in VBA is:
DoCmd.SendObject acSendReport, stDocName, "SNAPSHOT FORMAT", myEmail,,, mySubject, myMessage, FALSE
where: stDocName = Report Name
myEmail = email Address
mySubject = Outlook Subject Line
myMessage = Outlook Message
We no longer have ANY Windows 2000/ Access 2000 users, so we can't use their machines
We only have 2 remaining Windows XP machines and they are destined for upgrading to Windows VISTA machines
any help would be welcomed, thanx
for employees who are getting direct deposit checks we want to email a copy of their check stub to them (formerly we snail-mailed them).
In VBA, I cycle through a list of the direct deposit recipients, and email each one using SendObject.
my problem: works perfectly in Windows 2000/Access 2000
in Windows XP/Access 2003, asks if I really want to do it for each employee
in Windows VISTA/Access 2003: doesn't work at all; get the following error message:
____(application name)____ CAN'T OPEN THE EMAIL SESSION
the command I am using in VBA is:
DoCmd.SendObject acSendReport, stDocName, "SNAPSHOT FORMAT", myEmail,,, mySubject, myMessage, FALSE
where: stDocName = Report Name
myEmail = email Address
mySubject = Outlook Subject Line
myMessage = Outlook Message
We no longer have ANY Windows 2000/ Access 2000 users, so we can't use their machines
We only have 2 remaining Windows XP machines and they are destined for upgrading to Windows VISTA machines
any help would be welcomed, thanx