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, "(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."
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top