I have a line in my code that sends a report (as .rtf) to a list of people using outlook - it all works perfectly except for one thing - i want to add in From: as a number of people will be using the database but i want the e-mail to appear to come from a shared/group mailbox (we all have permissions for it) - anyone any ideas - the syntax for the command in access doesnt seem to allow for From:
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]
