Search results

All, I'd appreciate any help that can be offered, I've searched through many pages of posts on Comboboxes but not seem to fit the problem I'm having, either that or I'm missing the answer as I'm an access newbie. I'm 95% of the way to completing a project to allow payroll staff to log...

Thanks Missinglinq, I managed to resolve the issue. I originally had the email address as a hyperlink in one of the tables, then converted it to text. As a result the email address effectively ended up twice. Thanks again. Dave

Missinglinq, Thank you very much for posting the reply. I've changed the code and now the email generates, however the to email address is in the format of 'FIRSTNAME.SURNAME@COMPANY.COM#mailto:FIRST.SURNAME@COMPANY.COM# Any idea what might be causing that? Thanks again. David

Hi Everyone, I'm very new to access/vba, but I'm trying to utilise some code I've come across to email details in a form to an employee. I've taken the original code and tried to modify it for my own use (without much sucess). When running the code below I get the error 'Data type mismatch...