I have a button set up to send an email when clicked. I intended to send an email to everyone in a table, however I keep getting the following message:
Runtime error '2295'
Unknown message recipient(s); the message was not sent
This is because the names are in the format SURNAME, FORENAME as they would be in the outlook address book. If I use the full email address ie. forename.surname@whatever.co.uk then it works fine, but ideally I need to be able to use their name as the e-mail addresses are not in a consistent format and I can't easily add an email address every time a new person is entered. Does anyone know how I can force outlook to recognise addresses in this format from Access (both are the 97 versions by the way)? Incidentally if I type in SURNAME, FORENAME in Outlook it works fine. I am using the code:
DoCmd.SendObject ......
Runtime error '2295'
Unknown message recipient(s); the message was not sent
This is because the names are in the format SURNAME, FORENAME as they would be in the outlook address book. If I use the full email address ie. forename.surname@whatever.co.uk then it works fine, but ideally I need to be able to use their name as the e-mail addresses are not in a consistent format and I can't easily add an email address every time a new person is entered. Does anyone know how I can force outlook to recognise addresses in this format from Access (both are the 97 versions by the way)? Incidentally if I type in SURNAME, FORENAME in Outlook it works fine. I am using the code:
DoCmd.SendObject ......