DoCmd.SendObject error with MS Outlook

  • Thread starter Thread starter gbanks
  • Start date Start date
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."
 
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
 
Back
Top