G
gbanks
I use the code below to send a table from my db as an
attachment. It works well except on one users pc. When she
clicks the button that this is under she gets the
following error message "The operation falied due to
netowrk or other communication problems. Check your
connections and try again.". I'm using Access 2000 and MS
Outlook for the email. Is it in the setup of her MS
Outlook? Any thoughts? Thanks....
Dim strTableName As String
strTableName = "DataBaseChanges" & Format
(Now, "mmddyyyyhhmmss")
DoCmd.SendObject acSendTable, strTableName,
acFormatHTML, "(e-mail address removed)", "(e-mail address removed)", , "DBChan
ges", "Changes have been made to your database. Changes
are attached. Thanks."
DoCmd.OutputTo acTable, strTableName, "HTML
(*.html)", "\\server82
\is_prod_01#\DB\Changes\ChangeLogs\ " & strTableName
& " .html", False, ""
MsgBox "Table Send\Updated Completed."
attachment. It works well except on one users pc. When she
clicks the button that this is under she gets the
following error message "The operation falied due to
netowrk or other communication problems. Check your
connections and try again.". I'm using Access 2000 and MS
Outlook for the email. Is it in the setup of her MS
Outlook? Any thoughts? Thanks....
Dim strTableName As String
strTableName = "DataBaseChanges" & Format
(Now, "mmddyyyyhhmmss")
DoCmd.SendObject acSendTable, strTableName,
acFormatHTML, "(e-mail address removed)", "(e-mail address removed)", , "DBChan
ges", "Changes have been made to your database. Changes
are attached. Thanks."
DoCmd.OutputTo acTable, strTableName, "HTML
(*.html)", "\\server82
\is_prod_01#\DB\Changes\ChangeLogs\ " & strTableName
& " .html", False, ""
MsgBox "Table Send\Updated Completed."