Is access 2010 better for emailing reports?

[Edley7]

Hi, I'm a small business owner in the UK with 3 employees and considering upgrading from Access 2003 to Access 2010.



We use a bespoke access database to handle bookings (we're a travel company) and find the 2003 version very poor when it comes to emailing a report to clients and suppliers - we currently publish the rpt to word then cut and paste into an email but formatting is lost or changed and it's generally unsatisfactory.

Has Access 2010 improved any of this?

Many thanks

[NoellaG]

Hi,

even with Access 2003 you could send a mailing with attached report. Example: for each customer I first create a PDF file (for Access 2003 you had to download an add-in to be able to do this but with the constant acFormatSNP you can create a snapshot file), then create and send a mail message to all customers with the created file as attachment.

Example:

create PDF

strFile = [get or type here the location for the file and the filename]  & Format(Now, "YYYYMMDD_hms") & ".pdf"
DoCmd.OutputTo acOutputReport, strR & "_PDF", acFormatPDF, strFile, False

Send mail:

Public Function CreateMailMessage(strTo As String, strSubject As String, strBody As String, strFile As String) As Boolean
On Error GoTo Err_CreateMailMessage

    Dim appOutlook As New Outlook.Application
    Dim msg As Outlook.MailItem
    Dim intpos As Integer
    
    Set msg = appOutlook.CreateItem(olMailItem)
    
    intpos = InStr(1, strTo, "#")
    If intpos > 1 Then strTo = Left(strTo, intpos - 1)
    msg.To = strTo
    msg.Subject = strSubject
    msg.Body = strBody
    msg.Attachments.Add (strFile)
    msg.Display
    
    CreateMailMessage = True

Exit_CreateMailMessage:
    Exit Function
    
Err_CreateMailMessage:
    Debug.Print Err.Number & ": " & Err.Description
    CreateMailMessage = False
    Resume Exit_CreateMailMessage

End Function

greetings
NG

[NTC]

A Report itself is an Access object intended to be viewed by users of the Access database. Which maybe is why your process today is a bit of a kludge....

Beginning with Access07 there is now a native export to pdf (you find that icon in the ribbon - no programming required). It is the pdf that one attaches to the email to send. I think you'll find it works good.