A.D.Tejpal
adtp at airtelmail.in
Wed Mar 26 23:46:42 CDT 2008
Rocky,
My sample db named Report_SendInMailBody might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
You could adapt the underlying approach suitably, for your specific needs. Brief description is given below.
Best wishes,
A.D.Tejpal
------------
Report_SendInMailBody (Sample Db)
Brief Description
============================
(a) This sample db demonstrates sending an access report by placing it in the body of eMail message.
(b) Though sending a report as an attachment, using DoCmd.SendObject command is pretty straightforward, including it in the body of eMail itself, requires some extra measures.
(c) Word and Outlook objects are used in this approach and should therefore be available on sender's computer.
(d) It should also be ensured that Word is the default editor for Outlook. (click Tools > Options > Mail Format, make sure that check box labeled "Use Microsoft Word to edit e-mail messages" is in selected state).
Note: Each time Outlook is used for sending messages programmatically, the user is required to clear a warning message (informing that some program is trying to send a message through Outlook). If manual intervention in this regard is to be circumvented, third party utility like ClickYes could be used.
Version - Access 2000 File Format
References: Outlook Object Library
Word Object Library
============================
----- Original Message -----
From: Rocky Smolin at Beach Access Software
To: List
Sent: Thursday, March 27, 2008 05:42
Subject: [dba-Tech] Word Doc in an Email
Dear List:
I have a nice press release from Apress on my book - nicely laid out with
with their header. It's in a word doc and I'd like to insert the whole
thing as it appears in an email instead of sending it as an attachment which
may get blocked or not read. How best to do that?
MTIA,
Rocky