Concatenation & Sending Email via Lotus Notes

[virgirl920]

I'm looking for code and help with implementing the following idea. I have a form that is directly bound to a query. Depending on different user choices, the query will be different. Among many fields displayed on the form (and query) are phone, fax, email, etc. What I want to do is take all of those email addresses and send an email to them via Lotus Notes.

There are two issues to this, I believe.

The first is that I have to concatenate all of the email addresses and add commas. I have no idea how to do this.

The second is that I need to open up Lotus Notes and place those concatenated email addresses in the "to:" section, but NOT send the email. I've tried various codes to send email that I have found online, but all send the email automatically, and when I take out the "send" part, nothing in Lotus opens up.

I want all this to happen on the push of a command button.

I see in the "Code Repository" section that there is code to send email, but I am very new to Access, and I am not sure that it does what I want to do. Also, I still have that concatenation problem.

I would appreciate any help, and if anyone responds with ideas, can you please tell me where to place the code, as I am always unsure of that too.

Thanks so much!

 

[szymek_d]

Take a look at this thread. It might point you in the right direction.

http://www.access-programmers.co.uk/forums/showthread.php?t=87589

I used code written by "godofhell" it's a attached to one of his replies.

I dynamically create a query that generates all the email addresses that i want, then i used Email.zip to do concat and display all the emails in a memo box. From there on i just do one cut and paste to my email client. It works really nice.. and is really simple to implement.

 

[PaulWilson]

This is obviously an old question, but for other users...

You might want to take a look at a microsoft template. It's their Tasks database. It's a rather simple database of two tables but it has an embeded macro on the contacts form. You double-click on the email address and it opens up an email client. We use Lotus Notes so it opens that.

Another form encapsulates a task as an email body.