emailing from a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cameron - 17 Nov 2006 19:17 GMT

Recently, a user came to me and said that the email code that use to run as
of last week no longer runs in the database I support. The odd thing was with
this request is that not everyone had the function stricken. But if a user
that couldn't use the email function logged into the computer of someone who
could use the function. The ablity to use the function was lost. What might
be the problem with the emailing ablity? The data is emailed as an rtf
report.

Reply to this Message

Cyberwolf - 17 Nov 2006 20:31 GMT

It would be helpful if you post the code being used.

Signature

Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

> Recently, a user came to me and said that the email code that use to run as
> of last week no longer runs in the database I support. The odd thing was with
[quoted text clipped - 3 lines]
> be the problem with the emailing ablity? The data is emailed as an rtf
> report.

Reply to this Message

Cameron - 17 Nov 2006 20:56 GMT

here is what the click event calls:

Private Sub Command52_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim stDocName As String

stDocName = "radar report"
DoCmd.SendObject acSendReport, stDocName, acFormatRTF, , , , "RADAR",
"New RADAR for your information"
'DoCmd.SendObject acSendReport, stDocName, acFormatHTML, , , , "RADAR",
"New RADAR for your information", True

End Sub

> It would be helpful if you post the code being used.
>
[quoted text clipped - 5 lines]
> > be the problem with the emailing ablity? The data is emailed as an rtf
> > report.

Reply to this Message

Cyberwolf - 20 Nov 2006 11:44 GMT

I am thinking it could be something in that users profile. The code posted
looks fine. If there was a change in software recently that may have had an
effect.

Signature

Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

> here is what the click event calls:
>
[quoted text clipped - 21 lines]
> > > be the problem with the emailing ablity? The data is emailed as an rtf
> > > report.

Reply to this Message