Trying to fetch combobox text in the email body of outlook

[kate2008]

Hello All,

I am trying to fetch combobox dropdown text (in the networks label ) into the email body but in vain.


Whichever networks are selected in the six dropdowns should go to email body as you can find in the attachement


Thanks,
Kate

 

[Cronk]

Firstly, your data design is flawed. Rather than having 6 networks/roles in the user account, these should be in a related table. What happens is there is 7 or 8 or 100 networks?

But to reply to your specific query,
bodytext = bodytext & iif(len(me.network1 &'')>0, me.network1 &', ','') & iif(len((me.network2 &'')>0, me.network2 &', ','') & ........

NB All the above quotes are single quotes, not double.