Darren - Active Billing
darren at activebilling.com.au
Wed Jun 16 23:26:42 CDT 2010
Hi Jack This actually looks promising - I'll pull the code to bits to see if I can use mine with it as I am building HTML tables and Emailing lists But it looks very promising - many many thanks for the link Many thanks Darren - Active Billing -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jack and Pat Sent: Thursday, 17 June 2010 1:34 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2003: Sending HTML Emails via Outlook with Signature I just did some searching and found this link related to your subject. Don't know if it's useful or if you've already seen it, but thought I'd pass it along. http://www.access-programmers.co.uk/forums/showthread.php?p=681746#post68174 6 jack -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active Billing Sent: Wednesday, June 16, 2010 11:04 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2003: Sending HTML Emails via Outlook with Signature Hi Heenan Thanks for the link - no joy I have played with these things for many an hour and tried them in various combinatios - no soap It seems there is no way to include the signature AND have Word as the default email editor I'd love someone to show me otherwise. What a crock :-( Many thanks Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Wednesday, 16 June 2010 2:21 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003: Sending HTML Emails via Outlook with Signature Darren, Did a quick Google and found this ref. in books.google.com (no word-wraps all the way to "=true" at the right end) http://books.google.com/books?id=bw4Bw0idUCgC&lpg=PA285&ots=m0Ew_YdsIu&dq=In spector.EditorType&pg=PA285#v=onepage&q=Inspector.EditorType&f=true Read the sample page and you will see that it all ties to setting the HTMLBody property or the Body property. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active Billing Sent: Tuesday, June 15, 2010 11:26 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003: Sending HTML Emails via Outlook with Signature Hi team In my access app I am building HTML Strings to insert into Outlook as email bodies - I have all this working OK <snip> Does anyone know a way in code to turn "Use Word as editor" off until the email is built and then turn it back on? I've managed to get this close If olInspector.EditorType = OlEditorType.olEditorWord Then MsgBox "IT IS WORD" ''Email body will be missing signature Else MsgBox "IT ISN'T WORD" ''email body is perfect End If But am unable to find a way to toggle the olInspector.EditorType Hope it all makes sense - Thanks in advance team Darren -- 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.829 / Virus Database: 271.1.1/2940 - Release Date: 06/16/10 02:35:00 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com