DoCmd.SendObject error with MS Outlook

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, "[email protected]", "[email protected]", , "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."
 
P

Pieter Wijnen

sounds like one outlook dll or the other is not working properly on her
machine (or access ..)
try repairing/reinstalling/ service packs on her machine
we are after all talking about umpteen dll's, exe's ocx'es whose reg entries
might have been f***.ed

pieter
 
Top