Email - getting rid of the extra in To:

[torb123]

I have a form that sends an invoice via email to a customer. To get the To: line I use a D-Lookup, but since the field is a hyperlink, it puts unnecessarytext in the To: Line.

My D-Lookup is: .To = DLookup("[Contact1Email]", "Customers", "[CustomerID]=[Forms]![Orders]![CustomerID]")

It puts in the To: line in this format: address@domain.com#mailto://address@domain.com#

As you can see I don't need any of the text between the # signs. Is there a way to just get the DLookup to take the text out of the field rather than the text and link, or to get it to delete the pound signs and everything inbetween?

Thanks

 

[PHV]

Take a look at the HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[torb123]

That did it, thanks. My new code is:
.To = HyperlinkPart(DLookup("[Contact1Email]", "Customers", "[CustomerID]=[Forms]![Orders]![CustomerID]"), acDisplayedValue)