E Mail using a hyperlink address

[monplankton]

Understand, Sorry I missed the dims you set. I was too focused on the strAtach. I'm doing this between other jobs and It's 4:30am here. Thanks for you help got there in the end.

 

[pbaldy]

Happy to help.

 

[monplankton]

Paul, If I want to add an If statement to this code (if there was nothing in the text50 field) how would I go about it?

 

[pbaldy]

If Len(Me.Text50 & vbNullString) > 0 Then

will check the text box for both Null and a zero length string.

 

[monplankton]

Thanks again Paul

 

[pbaldy]

No problemo!