Access to Word to e-mail

[devious_dude]

I have an Access 2007 Database, containing Dues records for a Membership type application. Each Month I produce a Newsletter vis Publisher 2007, which ends up in PDF format. e-mail Address information is in Outlook 2007, snail mail adress info is in Access.

I want to be able to send an e-mail (Merge ??) to all those who have e-mail, with the Newsletter as an attachment, and with the Dues data in the body of individual e-mails (Merge ??). As the data resides in a number of applications, can someone point me in the direction I should take to achieve this.

Ross

 

[GaryPanic]

easiest way use one the emailing sample d/bases - and mailshot9email) out a pdf file putting the email address in the bcc field .

regards