D
Dave
Hi all,
I thought I had figured this out, but it's back.
I have a macro that runs overnight which updates various databases in our
network. Part of the macro sends out reports each Friday via email. These
emails are sent using a VBA procedure for each email required. If I run the
code, it works fine, but when the macro runs in the mde after the front end
is distributed, I get a message saying: The command or action 'OutputTo'
isn't available now.
Can anyone suggest why this error occurs and a possible fix?
The line of code for sending the email is:
DoCmd.SendObject acReport, "R_Email", "Snapshot Format", strToList,
strCcList, strBccList, "System update - " & Date, strBodyText & Format(Date,
"long date") & "." & vbCrLf & vbCrLf & strBodytext2, False, ""
Thanks in advance
Dave
I thought I had figured this out, but it's back.
I have a macro that runs overnight which updates various databases in our
network. Part of the macro sends out reports each Friday via email. These
emails are sent using a VBA procedure for each email required. If I run the
code, it works fine, but when the macro runs in the mde after the front end
is distributed, I get a message saying: The command or action 'OutputTo'
isn't available now.
Can anyone suggest why this error occurs and a possible fix?
The line of code for sending the email is:
DoCmd.SendObject acReport, "R_Email", "Snapshot Format", strToList,
strCcList, strBccList, "System update - " & Date, strBodyText & Format(Date,
"long date") & "." & vbCrLf & vbCrLf & strBodytext2, False, ""
Thanks in advance
Dave