email help needed

A

AJ

Can someone tell me why the following doesn't work. Note it works perfect if
none are = 0, but if one does = 0 it does not work.

Thanks in advance.

msgstring1 = IIf(Me.Combo464 = 0, "", Me.Combo464.Column(1) & ";")
msgstring2 = IIf(Me.Assigned_To_2 = 0, "", Me.Assigned_To_2.Column(1) & ";")
msgstring3 = IIf(Me.Assigned_To_3 = 0, "", Me.Assigned_To_3.Column(1) & ";")
msgstring4 = IIf(Me.Assigned_To_4 = 0, "", Me.Assigned_To_4.Column(1))

DoCmd.SendObject acSendNoObject, , , msgstring1 & msgstring2 & msgstring3 &
msgstring4, , , , , , False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SendObject help requested 2
sendobject problem 0
email problems 9
Need some PWA help 0
VBA - (re-) Set a Table Style 2
Cumulative formula for word table 0
Border formatting row of cells 22
Formula help needed 1

Top