Merge to Word from Access DB

[JeremyWeisser]

Hi,,

I am working on an Access contact database for a client. The database has different groups of contacts and I am trying to figure out a solution to send e-mails to these groups.

The client's mail server restricts sending e-mail to more than 50 addresses at once which is why I chose to use the MS Word mail merge feature because it sends e-mail to all recipients seprately.

Though the solution works it is not intuitive enough to use for the client. I am wondering if there is an easier way of doing this? Right now the user has to go into Word and manually configure the merge and all details about the data. Is there any way I could program some sort of Access control to open up Word with the recipients already selected so the process is simplified?

Thanks for the help in advance,

Jeremy

[Sn00pY]

mail merge it...use the Access VB plugin thing and make a macro for it...so he just clicks it and it does it...

[JeremyWeisser]

Cam you be a little more specific?

[Sn00pY]

Access has a Visual Basic element within it if recall...use this to create a macro and save the guy having to re-mail merge everytime via Word...

dunno if that helps been a while since i really used access :/

[mlerner]

install your own mail server to send the emails.

[JeremyWeisser]

Thats basically what I have been doing up until now but the merge still has to be created for each group everytime