Hi Everybody. I'm absolutely no expert and don't know any action scripting. I've looked at many of the posts on the forum about this subject but I'm confused and need help. It seems that reportmailer would help me, is it still available for V8 and how do I get it if I need it?
I have an account set with an end of month statement report. This produces a report record for each of 35 customers, obviously each one totally different. I want to automatically send each individual report record to each individual's email address. I have a separate table for customer details which contains a field with their email addresses. I could make this a part of the set, or I could create a field within the account table (part of the set) to store the customer's email address.
At the moment I am querying the record by customer number, which is a 3 character character field, this is also the case in the customer details table. So I get the record by customer number and choose to send by email as a pdf attachment, choose the email address by filling in the same 3 character customer code so that the email client (outlook express) finds the address from its own address book and press 'send'. Unfortunately this means doing it 35 times and I could really use a button on each report record that sends the pdf in an email, or even better a button somewhere that sends each record to each recipient itself, while I have a cup of coffee.
Thanks in advance, Trevor.
I have an account set with an end of month statement report. This produces a report record for each of 35 customers, obviously each one totally different. I want to automatically send each individual report record to each individual's email address. I have a separate table for customer details which contains a field with their email addresses. I could make this a part of the set, or I could create a field within the account table (part of the set) to store the customer's email address.
At the moment I am querying the record by customer number, which is a 3 character character field, this is also the case in the customer details table. So I get the record by customer number and choose to send by email as a pdf attachment, choose the email address by filling in the same 3 character customer code so that the email client (outlook express) finds the address from its own address book and press 'send'. Unfortunately this means doing it 35 times and I could really use a button on each report record that sends the pdf in an email, or even better a button somewhere that sends each record to each recipient itself, while I have a cup of coffee.
Thanks in advance, Trevor.
Comment