Arvo,
I've got the following code which is used to send details of a
specific record, as rich text, to authorised persons requesting they
then approve/action the necessary information.
Private Sub Command1217_Click()
Dim stDocName As String
Dim stLinkCriteria As String
On Error GoTo email_Err
MsgBox ("By clicking on this button, you will both save and e-mail
the current Reject record."), vbOKOnly
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70
stDocName = "Reject_Report_1"
stLinkCriteria = "[NCR]=" & "'" & Me![NCR] & "'"
DoCmd.SendObject acReport, "Reject_Report_1",
"RichTextFormat(*.rtf)", "", "", "", "NCF Reject Report", "A Reject
form has been generated from a raised NCF and actions have been
allocated to you. Please review the NCF database for full details. ",
True, ""
email_Exit:
Exit Sub
email_Err:
MsgBox Error$
Resume email_Exit
End Sub
OK, it may not be pretty, but it works quite well so I figured why
play with it. Anyway, of late out IT mob have been upgrading those on
Office XP to Office 2003 which has been causing me a few headaches.
Till they upgraded, the above code was working like a treat. However,
now either the text string that is supposed to be included in the
message either does not come up when the message is generated, it only
pops into the message when it's sent, or it just does not show up at
all! Most people do not seem to care that it's started to happen,
however Senior Managers are potentially going to get grumpy and I need
to work out how to fix it. IT are of no help (so far). Nor can I
work out why some users application stops responding if they cancel
sending the message. Again, some PC's just hang, others close the
send window etc OK.
I've got the users I know of to "allow" and run all the code when they
start Access, however it's still hit and miss. Right now, it seems
it's got something to do with the Access security and Sandbox stuff
they've set up, but working around it is seemingly impossible. I have
not yet needed to but work making the mdb file an mde file work? The
file's split. Suggestions would be most appreciated.
Regards,
Stinky Pete ;-)