Emailing using outlook

[Dan]

I have a form that I email the information from and it
works on some of the computers but when I copy the file
(front end) to another computer it won't work. It says
that there is an error in loading the dll.

It sends the information using outlook and on every
computer Outlook appears to be set up correctly and the
same(I can send and download my emails to).

Here is the code that I use to email the information:

Set objOutlook = CreateObject("Outlook.application")
Set email = objOutlook.CreateItem(olMailItem)

With email
.To = EmailAddress
.Subject = ref
.BodyFormat = olFormatHTML
.HTMLBody = EmailHeading & Info & Notes
.Display

I don't understand why it only works on 3 of the 6
computers. Outlook is set up the same, All the computers
has Office xp with the same front end part of the file.

Any help and or suggestions would be awsome. You guys are
the best and most knowledgeable.

 

[Eric Cárdenas [MSFT]]

I have a form that I email the information from and it
works on some of the computers but when I copy the file
(front end) to another computer it won't work. It says
that there is an error in loading the dll.

It sends the information using outlook and on every
computer Outlook appears to be set up correctly and the
same(I can send and download my emails to).

Here is the code that I use to email the information:

Set objOutlook = CreateObject("Outlook.application")
Set email = objOutlook.CreateItem(olMailItem)

With email
.To = EmailAddress
.Subject = ref
.BodyFormat = olFormatHTML
.HTMLBody = EmailHeading & Info & Notes
.Display

I don't understand why it only works on 3 of the 6
computers. Outlook is set up the same, All the computers
has Office xp with the same front end part of the file.

Any help and or suggestions would be awsome. You guys are
the best and most knowledgeable.

--------------------
You didn't post the actual error message so I can only give you general
advice. It's possible that a dll is missing or not properly registered. You
can run filemon and regmon, utilities available from
http://www.sysinternals.com to track down the missing or improperly
registered dll. You should run filemon and regmon on a machine that works
and on another machine that doesn't. Then compare the text output.

Hope this helps,