 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Send Email with File Attachment
Hi Is it possible to send an email with file attachments using the SendObject Action? Alternatively is there another method to do that? Thank you, Samuel Hi Samuel, It is certainly possible to send (1) attachment using SendObject, as long as the attachment you want to send is an object (table, query, etc.) within your database. If you are using Outlook (not Outlook Express), you can use code shown on page 17 of my "Access Links.doc" Word document. You are welcome to download a zipped copy from here: http://home.comcast.net/~tutorme2/samples/accesslinks.zip Access MVP Arvin Meyer has some code samples available for Outlook as well: http://www.datastrat.com/Code1.html (See "OutlookEmail.txt" and "MultipleMail.txt") Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > Hi > [quoted text clipped - 3 lines] > Thank you, > Samuel All I want is to send a report with a picture but the picture disappears when I use the email option > Hi Samuel, > [quoted text clipped - 31 lines] >> Thank you, >> Samuel > All I want is to send a report with a picture but the picture > disappears when I use the email option The only export format that supports graphics is the Snapshot format and the new PDF option in Access2007.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hi Samuel, If you can send the attachment in the Microsoft Access Snapshot (*.snp) file format, then you should be home free. However, this would require that the receipient has the free viewer utility installed on their Windows-based PC. Here is an example of how to do this: DoCmd.SendObject acReport, "Report Name", OutputFormat:=acFormatSNP, _ To:="Email Address", Subject:="Email Subject", EditMessage:=True This thread, from Dec., 2004, gives more details: http://groups.google.com/group/microsoft.public.access/browse_frm/thread/2f52f43 7605face7/3cb254d13a623323 I think you can also programmatically export to a .PDF file, and then use code for Outlook to send this file. You can try using Stephen Leban's Report to PDF method to create the .PDF file, and then use my code (or Arvin's code) to send the file using Outlook (not Outlook Express). Report to PDF http://www.lebans.com/reporttopdf.htm Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > All I want is to send a report with a picture but the picture disappears > when I use the email option Warning; Tom Wickerath is a cry baby database pussy and you shouldn't listen to him for anything go and talk to someone that knows SQL Server, kids > Hi Samuel, > [quoted text clipped - 24 lines] > > - Show quoted text - MVP Tom Wickerath's advice and suggestions stand or fall on their own merits, as do those of everyone else who posts replies in these newsgroups. the exception, of course, are personal attacks - which do not point out flaws in the posted advice or suggestions, and offer valid corrections or fixes or alternatives, but are merely unpleasant to read. in those cases, my suggestion is to block the sender, so as to avoid wasting time reading these types of posts. > go and talk to someone that knows SQL Server, kids my advice is that this suggestion is not useful, because this newsgroup is devoted to MS Access. so one must assume that the post-er is using Access, but not in conjunction with SQL server - or that the origin of the data has no bearing on the question - unless s/he specifically includes it in the post...and indeed the original and subsequent posts in this thread do not include SQL server in any way that i can see. hth Tom Wickerath is a f.cking PUSSY he doesn't know how to use SQL Server; or else he would surely promote ADP ADP is vastly superior no more linking connection strings import problems? NOT WITH SQL SERVER MDB cry babies can f.ck yourself > MVP Tom Wickerath's advice and suggestions stand or fall on their own > merits, as do those of everyone else who posts replies in these newsgroups. [quoted text clipped - 14 lines] > > hth there is 'no such things' as access without SQL Server sorry it doesn't exist any longer; it has been reccomended to move to SQL Server for a decade > MVP Tom Wickerath's advice and suggestions stand or fall on their own > merits, as do those of everyone else who posts replies in these newsgroups. [quoted text clipped - 14 lines] > > hth Note that this person is really A a r o n K e m p f and that he is not an employee of Microsoft. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Tom - You reference your code or Arvin's code to send the PDF file in Outlook....can you elaborate? I've been trying to find out how to send a PDF after using Lebans ReportToPDF, but have been unsuccessful. I want to automate the whole process, with no user intervention or having to attach a file in an email message. Thanks. Jeff G > Hi Samuel, > [quoted text clipped - 29 lines] >> All I want is to send a report with a picture but the picture disappears >> when I use the email option >You reference your code or Arvin's code to send the PDF file in >Outlook....can you elaborate? I've been trying to find out how to send a >PDF after using Lebans ReportToPDF, but have been unsuccessful. I want to >automate the whole process, with no user intervention or having to attach a >file in an email message. Microsoft Access Email FAQ http://www.granite.ab.ca/access/email.htm Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Hi Jeff, Take a look at my first reply in this thread, dated 6/24. I provided a link to a zipped Word document, that I call "Access Links.doc". There is a procedure shown on page 17 of this document. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > Tom - > [quoted text clipped - 7 lines] > > Jeff G Tom - That's along the lines of what I want to do, but more specifically, I want to run the ReportToPDF, which generates the PDF, and send the file that was just created without actually saving it to the disk. In your code, it looks like it's using wildcards to send the files. I want to send a single file. The process map would be like: 1. Generate the PDF using ReportToPDF 2. Programmatically set up an email message with that PDF as the attachment, with some items filled in already (i.e. SendTo, Message Body, and attachment). 3. Leave no remnants of the snp or pdf files. Like I said, I have both the ReportToPDF and your SendMail modules in my database, but can't figure out how to get them to do what I want. Thanks. Jeff > Hi Jeff, > [quoted text clipped - 22 lines] >> >> Jeff G Jeff I have combined the e-mail code from Tom and the ReportToPDF code from Stephen into a single module. You can import the module into your project and then to email a report as a PDF file you can just call a single sub-routine which does everything automatically (in exactly the way you described). If you would like a copy of the code (providing Tom or Stephen do not object) just email me at peter.hibbs@btinternet.comNOSPAM (leave off the NOSPAM bit) and I will send it on. Peter Hibbs. >Tom - > [quoted text clipped - 43 lines] >>> >>> Jeff G Hi Peter, I have no objections, and I'm pretty sure that Stephen would be fine with it too. Thank You for taking this inititive! Jeff: In your last reply, you wrote: "That's along the lines of what I want to do, but more specifically, I want to run the ReportToPDF, which generates the PDF, and send the file that was just created without actually saving it to the disk." I don't think this is possible to use the ReportToPDF functionality, without first writing the file to the hard drive, if only as a temporary copy. My code is designed to send files that can be found on the hard drive. One could add code to delete the .pdf file after having sent it, and this would probably be fairly reliable, but, if Access happened to crash for some reason after writing the file, but before the deletion code was run, then you could end up with the .pdf file remaining on the hard drive. Depending on the method that you are using for sending e-mail, you would likely end up with a copy on the hard drive anyways, in the Sent Items folder of Outlook. You might also want to look into using Win2PDF (http://win2pdf.com). It can be programmed using VBA code. Another Access MVP, who uses this product, is very happy with it. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > Jeff > [quoted text clipped - 9 lines] > > Peter Hibbs. PS. Another possible solution is to use PDF Creator as it is open source and free. http://sourceforge.net/projects/pdfcreator/ Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.