Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook and Outlook Express conflict

Status
Not open for further replies.

wbuckles

Technical User
Feb 22, 2002
8
0
0
US
I seem to have run into a microsoft problem. I'm using a SendObject to send email attachments from user workstations (They fill out the address and client info on a form, then press "send" to send the report). The problem is, some of them pull up the Outlook Express Internet Connection wizard. The workstations all use Outlook 97 on exchange. How can I set Access to use Outlook and ignor Express?
 
This is how I run Outlook to send email and attachments, don't know if this is what u wanted it to do.

If (Not lstrTo = vbNullString) Then
'<start outlook application>
Set lobjOutlook = CreateObject(&quot;Outlook.application&quot;)
'<create new mail item (0)>
Set lobjMail = lobjOutlook.createitem(0)
Let lobjMail.subject = lstrSubject
Let lobjMail.HTMLBody = lstrBody '<add body>

Let lobjMail.to = lstrTo '<apply To list>

'Let objMail.cc = lstrCc '<apply CC list>
'Let lobjMail.bcc = lstrBCC '<apply bcc list>

'<add attachments>
Set lobjAttachment = lobjMail.attachments
lobjAttachment.Add path1, , , <Description of the file>
lobjAttachment.Add path2, , , <Description of the file>

lobjMail.send
lobjOutlook.Quit

End If

good luck
 
Woah. Solved it finally. Oversight on my part. The systems had had a new version of IE loaded, and it reset the default mail client in Internet Settings to Express.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top