output to outlook

[tios]

Hi all,

OK - very slowly getting the hang of this Access lark (and resisting the temptation to go running back to my beloved Excel)

I have a customer contact / mailing list (simple database, just one table).
Each entry can have up to 32 different contact categories (check boxes in a form), 26 of which are for contact by post and 6 are for email correspondance.

I've manage to create a selection form, query and report that generate mailing labels for the first 26 categories (v.happy!!)

Now for the bit I'm stuck on, I would like to create a selection form and query that when run creates an email in Outlook with all the matching records email address in the BCC field (users can then attach catalogues files etc and do whatever they like!)

I'm okay with the form and selection query - problem is how do I get the result into Outlook?

ps - new to posting, if this is far too long winded and irritating let me know!

 

[Corticus]

Welcome Tios,

This post gets into using the sendobject method to send automated emails, hopefully it will be of some assistance.
http://www.mrexcel.com/board2/viewtopic.php?t=175869

 

[tios]

Hi Corticus and thank you,

Great link, not to mention a sample database - I always find it much simpler working with existing examples (they used to call it copying in school!)

I'm pretty sure I can do what I need from here