Email from Access Using COM to Word

[Guest]

Hi All,

I'm using Access data to insert data into a Word doc, then email the doc out.
Using COM to email from Word using .Sendmail doesn't work as needed.

I can copy the data from Word onto the clipboard, paste it into an rtf
control, then use .SendObject using a form. The pasting is fine. When I email
it out, 2 things:
1> the formatted text is gone
2> the text is created as an attachment instead of the message text

Does anyone know a way to conquer these to issues ? I've been dealing with
this for 2 days now, and I'm starting to think about getting frustrated !

thanks

 

[david epsom dot com dot au]

1> the formatted text is gone

2> the text is created as an attachment instead of the message text

Yes, that is what .SendObject does.

What is wrong with .Sendmail?

URL's:
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Send Email using CDO/Outlook 98
http://www.mvps.org/access/modules/mdl0019.htm


(david)

 

[Guest]

Hi David,

Sendmail prompts me for Subject and To, defeating the purpose of automation.
I may not be doing something right, so maybe you could straighten me out on
that !

I need to roll thru a table and email all with a certain flag set.

thanks !

 

[david epsom dot com dot au]

Sendmail prompts me for Subject and To, defeating the purpose of
automation.

Yes, that would be a disadvantage :~(
I don't see anything that works like you want, but here's another URL:


How to send an email from Word using VBA
http://word.mvps.org/faqs/interdev/SendMail.htm

(david)

 

[Guest]

Yeah,

My solution was basically the last method. I really wanted to avoid sending
the email with an attachment, but there is no way to send formatted text in
the body of the email.

Thanks David !