retrieving a next data that is input

[ploz]

Hello everyone,

First I want to tell you I do not speak English so I went through a translator,
I am beginner in VBA
I entraint to make a production schedule and this schedule there is an administration interface with a combobox users.

I just added it a somewhat peculiar feature is that there will have a password button forgotten?

the user clicks on this button opens a userform (something I have already managed to do)

just a little more to detail I have a sheet that is named Admin
A column avond we identifier
column B the password
in column C the email address

if the user clicks Password Forgot goes eg [email protected] and face well in this one page that I named Admin
then the password and password sent to the email that is in column C

if the email address is not in the comic message "Email is not in our database"

thank you in advance for your assistancedemande mot passe.xlsm

[Bernie Deitrick]

This code requires that you have MS Outlook available, and that you create a reference to Outlook in your project.

demande mot passe.xlsm

This is the code for the commandbutton:

Please Login or Register  to view this content.

[Bernie Deitrick]

The site is not letting me edit my post: you might want to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[ploz]

Good evening,

I thank you so much for this encoding =) However Outlook and active well into my excel but I have a message that it puts in coding when I execute

Here the screenshot
Capture.PNG

thanks for your help
Best regards
Ploz

[Bernie Deitrick]

You need to set a reference to MS Outlook - I don't have Outlook (we went to webmail) but this is what your project references should look like. It should not say "MISSING" but you need to put a check mark in the box next to the Outlook application so that Excel can use it to send email.


Outlook Reference.JPG

[ploz]

re Goodnight

it's good does it work =)
My outlook was in uncheck references : s

again thank you for your help

[ploz]

re = )

I start to change a little the sentences it is possible that the password is not displayed in the msgbox ?

Please Login or Register  to view this content.

[Bernie Deitrick]

You made the changes correctly to the message box - the password is not displayed in the message box. But it is not transmitted in the email, so change the .Body parts to this (you need to build up the string step by step, which means you need to add new strings to the end of the old instead of just replacing all the text:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[ploz]

Frankly super thank you very much =)
over for me today I me leve early tomorrow morning

[ploz]

Hello,
I tested this morning my factory, it works only if outlook is open as me yesterday he put in execution outlook in the spot near the bar of the clock,
is there a way for it to execute in the background also
debugging code was at this line

ArticleDeCourrier.Send

Best Regards
PloZ

[Bernie Deitrick]

I don't have Outlook anymore to figure out what is needed - you might want to find an Outlook forum to ask a question like that - answers.microsoft.com has forums that should provide better help with Outlook.

[ploz]

ok thank you