CDO .from -> using variables

[Jamster45]

Hi There,

I have a form where i can send email from.
I want the user to fill in the senders name and the senders emailaddress.

The name is fixed but the emailaddress not, i need some help!

Here is the code

With mail
.To = Me.emailadres
.From = "" & Me.afzenderNaam & " <onzin@crap.nl>"

Someone an idea to make both fields variable?

 

[theDBguy]

Hi. You can just remove the fixed name and either ask the user to enter both together or use one more variable.

 

[Jamster45]

Well i tried that but then the fromaddress and fromname are the same then.
Any suggestion how to program it, like you said?

 

[theDBguy]

Well i tried that but then the fromaddress and fromname are the same then.
Any suggestion how to program it, like you said?

What is in Me.afzenderNaam? Is it coming from a table?

 

[Jamster45]

I have to fields in a form: FromName and FromAddress
They are not coming from a table.

 

[theDBguy]

I have to fields in a form: FromName and FromAddress
They are not coming from a table.

So, what happens if you tried:

.From = Me.FromName & " " & Me.FromAddress