Remittance via Email in Line 50 2009

[CJcat04]

Hi,
I am running line 50 2009 and want to send my remittances to suppliers via email rather than post.
I have set up email addresses in the supplier masters
I went into the Remittance layout and created one for email, but still have errors.
Under the email settings in properties I tried to add the to: address as per the supplier master but I can't seem to see the field?
When I run the remittance this is the error I get
"the email options for this report are not fully configured. do you want to send enture report as an attachement"
if I say yes, it seems to open email and have an attachement ready to send, but no email address and I was hoping it would send without me having to go through that process.

Sorry if I seem dim, I know my way around sage, but this is proving a nightmare for me!
thanks

[brucedenney]

The field you want to use is PROBABLY PURCHASE_LEDGER.EMAIL

The purchase ledger table is not linked in by default to the remittance layout.

Open the layout in the report designer and go to

Data>Joins

Drag the Purchase ledger table on to the working area.

You may need to join the Purchase_Ledger account ref to the account ref in the Remittance advice, or it might do it for you.