Sending E-Mail (1 Viewer)

vjmehra

Registered User.
Local time
Today, 08:56
Joined
Mar 17, 2003
Messages
57
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 ......
 

Users who are viewing this thread

Top Bottom