VBA error for textbox email address into address

[Patriot2879]

Hi, i got the code below where it autofills a email address in to textbox36 and i want this data to link into my email, i have used the code below but i get an error please can you help

aEmail.Recipients.Add = "UserForm1.TextBox36.Value"

 

[ranman256]

Re: VBA error for texbox email address into address

Dont put quotes around the textbox....it cant resolve this way, instead:
aEmail.Recipients.Add = UserForm1.TextBox36.Value

 

[Patriot2879]

Re: VBA error for texbox email address into address

hi thanks for that but unfortuantely i am still getting the error, below is the code i changed it too, i am getting a Run-Time error '499': Argument not optional, please can you help thank you in advance.

aEmail.Recipients.Add = UserForm1.TextBox36.Value

 

[daverunt]

Re: VBA error for texbox email address into address

Hi

does this do it?

aEmail.Recipients.Add(UserForm1.TextBox36.Value)

 

[Patriot2879]

Re: VBA error for texbox email address into address

Yes that works great thank you so much

 

[daverunt]

Re: VBA error for texbox email address into address

Glad it's working.

it's always worth a Google to look at the method example/syntax in MSDN

https://msdn.microsoft.com/en-us/vba/outlook-vba/articles/recipients-add-method-outlook

Recipients.Add(String)

 

[Patriot2879]

Re: VBA error for texbox email address into address

thank you for that