Carolyn Johnson
cjlabs at att.net
Wed Aug 13 10:37:14 CDT 2014
I've glanced at other options over the years but was trying to keep away from anything that has a DLL to deal with. I am thinking it's a permissions problem, but I don't know specifically what to tell the users to look for. The folder in which the generated pdf file is temporarily saved? I don't know anything about that side of things. Thanks Carolyn ----- Original Message ----- From: Jim Dettman To: 'Access Developers discussion and problem solving' Sent: Wednesday, August 13, 2014 10:15 AM Subject: Re: [AccessD] Error creating emails in Outlook in Win8 There's also vbSendMail, which some on the list have used. It does require a DLL to be registered however....someone had code for that though. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Wednesday, August 13, 2014 11:08 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Error creating emails in Outlook in Win8 Carolyn, I have a number of nightly "Access Batch Jobs" that create many reports in PDF format and automatically e-mail these PDF files to select employees. When I first started this project, I tried to use Outlook but ran into many time consuming issues. I then did some research and started to experiment with a free command line e-mail utility called Blat. Blat worked Okay, but when I ran into some problems, I spent a lot of time and could not get good answers from anyone, so I decided to try the free trial version of a command line e-mailer called Febooti. I had immediate success with Febooti and decided to purchase the product (less than $100). For the past two years, Febooti has worked very well for us. It was money well spent for us. You might not be interested in switching horses, but I thought that my experience might be useful to you. Brad Marks -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge Sent: Wednesday, August 13, 2014 9:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Error creating emails in Outlook in Win8 I did a google search and found similar messages. These links may be helpful, I hope. I am not an Outlook programmer, but thought the links or links within may be helpful. http://www.outlookcode.com/threads.aspx?forumid=2&messageid=33854 http://www.pcreview.co.uk/forums/reading-another-inbox-t1840585.html Good luck. On Wed, Aug 13, 2014 at 10:18 AM, Carolyn Johnson <cjlabs at att.net> wrote: > Cross-posted > > Access 2000 database, running in 2000/XP, 2007, 2010, 2013 on Win > XP/Vista/7/8 > > > I have a sub that saves a indivualized report as a pdf file, then > creates an email in Outlook (late binding) and attaches the report for that > individual. It's been working fine for years. > > Over the past few months, I've been hearing from users that they are > getting an error from Outlook -- Method 'Subject' of object'_Mailterm' > failed I haven't been able to find anything on this error when I do a > search, but anecdotally from my users, it seems related to the attachment. > Similar code without the attachment apparently works OK. > > I can't reproduce the error on my Win8 computer and am at a loss. > > > TIA, > Carolyn Johnson > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com