You can always use the Outlook object in VBA as long as you have Outlook installed on your PC.  Here is a sample code to create an email with recipient, subject, body, etc., and send it.


    ' Create a new MailItem.
    Dim m As Outlook.MailItem
    Set m = Outlook.Application.CreateItem(Outlook.OlItemType.olMailItem)
    
    m.Subject = "test sending attachments"
    m.Body = "Hello World" & vbCr & vbCr

    ' Recipient's e-mail address.
    m.To = "a_friend@whom_i_trust.com"

    ' Create attachment
    Dim a As Outlook.Attachments
    Set a = m.Attachments
            
    ' Attach attachments to email.
    a.Add "C:\My Documents\report1.pdf"
    a.Add "C:\My Documents\report2.pdf"

    ' Display email composition window.
    m.Display

    ' Send email.
    m.Send

Thanks Kevin. Our IT Company are setting up the access program on a Amazon server and I believe the problem is that it is just the access program that goes on there. No outlook so no outlook profile against the user. They have set up the Print2Email Server software so they can print to that which opens a generic looking email to send but of course there is no auto populating of things like the customers email and body text. Any ideas on that one? Thanks Nadia

You use Outlook on *your* PC, not on the server.  Outlook is not designed for servers anyway.  If you have Outlook installed on your PC, and your PC has a way to connect to your cloud database and pull data from it, my code above should work.  For instance, if your database tables contain your contacts' email addresses, you can pull them out to compose emails with such code.  Outlook has to be already configured to send/receive email properly first.  You can use any email provider with Outlook.