Sending Embedded Objects by Mail.

[Guest]

Hello,

Does anybody have an IDEA about how to send an Object Embedded (Excel or
Word File) in a Field of an Access Table. I have tried with the SendObject
method but it does not have a way of sending the specific OLE Field.

Is it possible to do it using MAPI, Earlier I had tried using it but it
could not send multiple mails one by one by looping thru a Database file. It
always only showed the last genereted mail and also sent only the last one.

-Vaibhav Joshi

 

[John Nurick]

I have a nasty feeling you'll need to write code that saves the embedded
object to a file and then attaches the file to the message.

 

[David C. Holley]

Try posting here: microsoft.public.outlook.program_vba
Their the Outlook experts and might be able to help.

 

[Guest]

Thanks John,
I knew I can do that. I need the exact steps to execute what you have said.
What do
I use for doing it ? MAPI or 'SendObject Command' ? I dont think I can
attach additional items using DoCmd.SendObject. So MAPI should be the only
left option. But with MAPI, I won't be able to send the Report/Query directly
to mail which also is the additional requirement in this case. I am looking
for sending a report and along with it should be able to send the embedded
file as an attachment.

Sorry David,
I have posted to the correct forum as I want this enabling in Access
Application. And any how when it comes to VBA code they are almost similar in
both cases. Also in Outlook when you have ready funcanality only a stupid
would think of using Winsock or MAPI for doing anything with mail. Still I
will again check out you suggestion.

In the mean while I am still looking for some sureshot solution.

-Vaibhav Joshi

 

[John Nurick]

Hi Vaibhav,

For various ways to send email, see
http://www.granite.ab.ca/access/email.htm

To save the embedded object to file, the simplest way is to use a form
with a BoundObjectFrame bound to the OLE field. Have your code navigate
the form to the record in question and then manipulate the
BoundObjectFrame's Verb and Action properties. There's antiquated code
(Access 95/Word 6) at
http://support.microsoft.com/default.aspx?scid=kb;en-us;132003&Produc...
showing the general idea.

It may also be worth taking a look at
http://www.lebans.com/oletodisk.htm