Query table and return all EMail address

[Renascentia]

Greetings

Firstly please excuse my ignorance as I know nothing about db/sql queries or MS Access - hence the reason I am here to pick your brains

I have a table of members where I would like to query and get their email addresses if not equal to null or an empty string. I would like the results displayed to me in the format of a CSV with semi colons as separators or similar (open to your suggestions) so that it is a simple case of cut and paste the results into an email where I would then be able to send an email to all members.

I hope this makes sense and I would like to thank you all in advance.

Renascentia

 

[pbaldy]

Welcome to the site. You'll find a lot of info on sending emails with Access here:

http://www.granite.ab.ca/access/email.htm

You can modify the sample code that loops a recordset sending an email to each recipient to build your string instead.