cc varible on e.mail (1 Viewer)

[rainbows]

the

this form has a combo box with people name in " send e.mail to " and after selecting that name the e.mail is sent to that person what I would like to do if possible is cc the manager of that company ( this database is used for 3 companies ) so if field " issues company " has PPI-ENGINEERING in it then CC steve,kirk @ ppi-engineering , if it has API - ENONEERING in it then CC steve.kirk @ api-enginnering is it possible to do this with an if statement or other way
thanks steve

 

[theDBguy]

In the combo for issues company, add a column for the cc email address and then use it in your code. For example:

.Cc=Me.ComboName.Column(x)

Where x is the column number for the email address minus 1.

 

[rainbows]

I have added a column in the company table and to the macro but I must have done something wrong as this just copies the words into my e.mail and not the e.mail address thanks steve

 

[theDBguy]

Try changing it to this:

=[Company].[Column](2)

 

[rainbows]

thank you. works great. now next part of the puzzel

 

[theDBguy]

thank you. works great. now next part of the puzzel

Hi. Glad to hear you got it sorted out. Good luck with your project.