Report Email Woes

[Kevin Field]

I currently have one report (they will expand dramatically when i get this figured out) which i want to email to an individual in snapshot format.

Now, ive used macros in the past to do this and im fully aware of the popup which shows up asking you for permission to send the email via outlook.

This time its different though, basically want i want to have is a form which will allow me to select a record via a drop down list and then an individual from a list as well. The individual information will be coming from a table i have called tblAdvisers and it has the email addresses for each person in column 3.

Is there any way that i can simply select an individual from the list, have access lookup the email address in column 3 and then prepopulate the email to be sent with that address?

Any assistance would be very gratefully recieved.

Thanks!

 

[pbaldy]

I would include the email address field in the row source of the combo. Then in your email code you can get the address with:

Forms!FormName.ComboName.Column(x)

where x is the number of the column containing the email address (0 based).

 

[Kevin Field]

I would include the email address field in the row source of the combo. Then in your email code you can get the address with:

Forms!FormName.ComboName.Column(x)

where x is the number of the column containing the email address (0 based).

Thats for the above. By the way, since the original thread, ive removed the combo box for something simpler. Now the email macro just needs to refer to the field [text43] which is a text box on a form which prefills with a valid email address.

However when i put this in the send object macro in the To: field and then run the macro, im getting the following message:

3, rptEmailFileCheck, SnapshotFormat(*.snp), [Forms]![frmPreFileCheckReportEmailSelector]![Text43], , , , , No,

Any ideas what i could be doing wrong?

 

[pbaldy]

What is your actual code? I don't use macros, so not sure about using them.