This is SOOO ANOYING!

[Babe_uk]

Hi guys, recently i just got help from some members who showed me how to send an email to an individual and to all the individuals from Access to Outlook Express..

I have a form which is called 'E-mail' and when i enter a subject and a message and click on the 'Send message' button i get a new window called 'Profile name" and 'Outlook Express is selected".. But when i click on "OK" button, there is an error message from "Microsoft Exchange" in FRENCH!

wHEN I CLICK OK, THEN THERE IS A run-time error...

I really don't know wat to do.. i think my Outlook express settings might be different but how can i check it/.??

I need urgent assistance pelase!

Thanx

 

[iangirven]

I had a similar problem with outlook. I required users to confirm some actions which required them sending an email.

If outlook wasnt open it came up with a profile request message. I couldnt find a way round this using vb code so I cheated a bit. I told everyone when performing this task to open outlook before starting the database. when they click on the button to send the emails it does it fine now.

I know this isn't probably what you want but it may suffice until you sort the code out.

if you do sort it id be interested in knowing how you did it.

regards
Ian

 

[mboe]

To Quote OSCSLeo:

You can use the following code to open outlook prior to executing your email

Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office97\Office\Outlook.EXE"
Call Shell(stAppName, 1)


HTH