Prev: Product SEarch Form/ Query
Next: Outline (function notation) :)
From: Simon on 2 May 2010 18:33
I have a button that saves a report as a PDF and removes the file name
based on the order number

stDocName = "rptOrderConformationWaterStream"
strOutFile = Me.Type & Me.OrderNumber & " Order Conformation" &
".pdf"
DoCmd.OutputTo acReport, stDocName, acFormatPDF, strOutFile


This works perfect, is there a way to do the same however attach the
PDF to an email to send
From: Arvin Meyer [MVP] on 2 May 2010 19:50
I use code I wrote some time ago:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:beb47d4f-cded-45a0-ba05-e8d61496b926(a)r11g2000yqa.googlegroups.com...
>I have a button that saves a report as a PDF and removes the file name
> based on the order number
>
> stDocName = "rptOrderConformationWaterStream"
> strOutFile = Me.Type & Me.OrderNumber & " Order Conformation" &
> ".pdf"
> DoCmd.OutputTo acReport, stDocName, acFormatPDF, strOutFile
>
>
> This works perfect, is there a way to do the same however attach the
> PDF to an email to send


 | 
Pages: 1
Prev: Product SEarch Form/ Query
Next: Outline (function notation) :)