Send Object Question (EASY)

[JUDO]

DoCmd.SendObject , "", "", Me![Text369] ???? Me.[Text371], "", "etc .........


I am now using the above code to send an email using text boxes on the form populated with the relevant recipients email addresses. The problem I have got is I don't know how to separate the code for each email address so that I can populate the TO... line with mutliple emails. I used to use the code below when the address was hard coded but I can not use the semi colon in the same way.


docmd.sendobject , "","", "james.dunk@seief.com; jobby@kksdnfsld.com",.etc


Please can you help me. (I told you it was easy)

 

[boblarson]

DoCmd.SendObject , "", "", Me.[Text369] & ";" & Me.[Text371], "", "etc

You just need to add the semi-colon in by adding it in by using an ampersand, the semi-colon in quotes and another ampersand.

 

[JUDO]

Bob.
I said it was easy if you know how, excellent works a treat thanks for the help.

Judo