Access emailing with GroupWise HELP!!! 1

[WynneSMI]

I'm send an auto-email message in Access using GroupWise. I can't seem to get the seperator between email address correct.(The email address are pulled from a table and put into a string). I have tried , ; <Enter> with spaces and without and nothing seems to work! When I look in my Sent Mail folder, both email address show up but it says only 1 Reciepient and only the first email address actually gets the message. Does anyone have any ideas??? Thanks.

 

[oharab]

I've never used groupwise before, but in Lotus Notes, you have to create an array of Addresses then assign that to the address property. It could work with Groupwise!

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

&quot;Where are all the stupid people from...
...And how'd they get so dumb?&quot;
NoFX-The Decline
----------------------------------------------

 

[WynneSMI]

Yeah, I think your right. Now do would you create an array of Addresses then assign it the address property with the email address in a table in VBA? Thanks.

 

[oharab]

Not sure if you're asking me a question, (it's been a long day & your english is a bit squiffy!)
If you are asking how to create the array then:

dim db as dao.database
dim rs as dao.recordset
dim aAddresses() as variant
dim i as integer

set db=currentdb
set rs=db.openrecordset(&quot;Addresses&quot

i=0

do until rs.eof
redim preserve aAddresses(i)
aAddresses(i)=rs!EmailAddress
i=i+1
rs.movenext
loop

groupwise.sendtoaddress=aAddresses()


hth
Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

&quot;Where are all the stupid people from...
...And how'd they get so dumb?&quot;
NoFX-The Decline
----------------------------------------------

 

[WynneSMI]

Sorry about the english ;p Anyway, thanks for the code! The module I'm using to send email through GroupWise uses a 2-D array, but I figured it out. Thanks again.

 

[ProCatHerder]

WynneSMI - I've just learned I need to modify my application to support both Outlook & GW. If you could share your code on the GW portion I would greatly appreciate it.

Thanks
Kim