Export Email address for a sales class

Options
Michael Coates
Michael Coates Member Posts: 2
edited January 2020 in Reckon Accounts (Desktop)
I have set up several classes over the years and they work well but i cant find any method of reporting to combine a class with a purchasers email details....

For example i have sold left hand screwdrivers and they were assigned a class "LHS"  Now i want to go back and find the email details for every person who we sold a LHS to so i can email them and say we have a new product for people who use left hands.

I cant find anyway to get the email details for a class of products sold, i just cant make it happen and need some help please.

Comments

  • Charley
    Charley Member Posts: 546 ✭✭✭
    edited January 2020
    Options
    Don't bother; classes are normally assigned to Income and expenses. Customers, suppliers etc are a whole of entity issue ie overall class.
  • Janos
    Janos Member Posts: 30
    edited February 2016
    Options
    Michael,
    I have a report that vaguely fits your description.
    I selected an A/R Aging Detail report. This has Class in one column. Then went Modify and added the "Name Email" field. Then went to filters and removed the "Paid Status" filter and added the wanted "Class" filter. This now gives me a full history of all purchases in the selected Class complete with the email address of customers. You can now manipulate date ranges and other filters to suit. Export to Excel and use it in a mail merge, or import into a group in your mail program.
    Hope this helps,
    Janos

  • Michael Coates
    Michael Coates Member Posts: 2
    edited February 2016
    Options
    Hey Janos, thanks so much....   It makes no sense but work a treat.  Saved me a lot of work Thank you.

  • Charley
    Charley Member Posts: 546 ✭✭✭
    edited January 2020
    Options
    Janos, didn't think of that :-)