Outlook Email Issues From Access - Email Report in Microsoft Access


	Back to Email Report Comments List

Upload Images @Reply Bookmark Link Email

Outlook Email Issues From Access

Leodan Chela

3 months ago

WHEN EMAILING FROM A FORM IN ACCESS,the field TO: is for example 34, IT PULLS THE CLIENT ID INSTEAD OF THE EMAIL-ADDRESS(it is inside of a combo box which the data source is a query by itself).
How can make outlook pull the email address instead of the client ID?

thank you!

	Kevin Robertson @Reply 3 months ago
I am assuming ClientID is the first column in your Combo Box and Email is in the second column. Either build your Combo Box without the ID (so Email is the only column), or you will need to access the Column property of the Combo Box: For example `msgTo = cboEmail.Column(1)`

	Leodan Chela OP @Reply 3 months ago

	Leodan Chela OP @Reply 3 months ago
Kevin thank you for your input, what happens is when I only pick the email address, it will now show me the ClientID only and not the email address, msgTo = cboEmail.Column(1)-> is this a VBA code? where do i put it? Maybe if we could make a video call will be ok if you can help me out if possible, thanks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Email Report.