Hi All

I'm going to be as specific as possible with this one as I'm struggling and I need pretty much step by step instructions

So I have a list of customers and their language and their email addresses. This information is now sitting in a table in Access

I want to create a form to show

Customer / Language - Combo box

Command Button - generates an email

So the email is going to be a standard email template which only very few things need to be changed for each customer

To - Needs to be populated with address from access table
cc - N/A
Subject - Needs to state only 'PEND'

TEXT - For now all it needs to say is 'PEND' as I can change this at a later point.

So this is the first thing I need to know how to do. secondly, I want the email to generate on the language as well. So say for example I pick the customer BT and the language is english, then the email text should be in the english template, however if the customer is French, I want the email generating the french template

Please can you let me know if this can be done?

Thanks