Sending email from access with attachment via Outlook Express6

[Irshad Alam]

Dear All,

I posted my query earlier but was not sucessful in getting the answer,
therefore, putting this as a new query :

How to send an email with pdf attachment via outlook express6.

I am aware that sendobject works but only with access attachments, but my
situation and requirement always is to send email with pdf file attachment
via outlook express 6

Requesting for a solution to complete this.

Note: I am using Windows XP, Outlook Express 6, MS Access 2000

Thanks and best regards

Irshad

 

[PieterLinden via AccessMonster.com]

like this:
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=24#24

 

[Irshad Alam]

Sir,

I viewed the webpage as mentioned below, downloaded the winzip file, opened
the files, but dont know how to use.

Please explain how to use that in access coding.

Regards

Irshad

 

[JP]

The short answer is, you can't automate Outlook Express using VBA.

--JP

 

[PieterLinden via AccessMonster.com]

The short answer is, you can't automate Outlook Express using VBA.

--JP

Really? That's funny... everything else I've ever used from Michael Kaplan's
website has worked as advertised. Did you actually try it or are you just
rejecting the notion out of hand?

 

[JP]

Notice I said "the short answer." You can find VB/VBA code here that
extracts and sends email using OE:

http://www.vb-helper.com/howto_extract_outlookexpress_email.html
http://www.vb-helper.com/howto_send_mapi_mail.html
http://www.vb-helper.com/howto_send_outlook_express_attachment.html

So you *can* create a kludgy workaround (although I'm still at a loss
as to why the OP's solution *requires* OE). But OE doesn't support
automation and doesn't have any objects you can instantiate.

--JP