send email through access

[needInfo25]

I would like to create an email message from Access based on a query. Query provides the email address. I would like the email address to be added to the 'to' line in the Outlook email message. Any help is appreciated!

 

[PWise]

docmd.sendobject

 

[AlexCuse]

Or, if you want to go the CDO route:

http://www.tek-tips.com/viewthread.cfm?qid=1246083

You have not really been clear on what you want to do with this email, but CDO offers a little more flexibility.

Hpe this helps,

Alex



Ignorance of certain subjects is a great part of wisdom

 

[needInfo25]

I have a form that has a button. Once the form is clicked it inititates a query. User is prompted to enter a parameter value (client number), the record is then displayed to the user. However, I would like to instead of displaying the record, create an email message with the email address of the client in the To line.

Thanks!

 

[needInfo25]

Also, would docmd.sendobject work here, because I really don't want to send an object, just use an email address to create an email.

 

[jfdabiri]

alexcuse,
is there anyway to modify this to send email from groupwise? i have an appp that can use this method.
thanks.

 

[AlexCuse]

needInfo -

At soem point I will have a look and see if you can make the email window visible and open for editing, I have never done so before. But you could certainly pop up a form where the user can edit the body, subject, to and from strings and click send.

jfdabiri - I have seen it discussed on here, but I am not familiar with Groupwise. Here is a link to someone's code on email from Groupwise though, looks like it uses SendObject rather than CDO.

http://www.tek-tips.com/viewthread.cfm?qid=1330180&page=5

It's pretty recent, so if you reply to it maybe the poster will show you how they got it to include an attachment?

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[jfdabiri]

thanks alexuse,
i looked at his code. i guess it's pretty simple. he's got a docmd, which is unique to vba. what do i code in its place in vbscript?

 

[AlexCuse]

Ah, didn't know you wanted it for vbScript... YOu might want to post this in the vbScript forum.

Is SMTP enabled on your mail server? If it is, I know how you can send.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom