Sage help please - emailing customer statements
Gem7321
Registered Posts: 1,438 Beyond epic contributor 🧙♂️
Hi all
I have set up a template in Sage to email customer statements which works brilliantly. However, the problem I have is that it is emailing to customers even with the 'I email statements etc' box unticked. It would be too time-consuming for us to individually select which customers we want to email statements to, we would like to be able to 'swap' then email the statement but for it to leave out any that do not have this box ticked. Can someone tell me what I'm doing wrong?
Also, is there any way I can generate a list of statements that have not been emailed to show us the ones that we need to print and post?
Thanks
I have set up a template in Sage to email customer statements which works brilliantly. However, the problem I have is that it is emailing to customers even with the 'I email statements etc' box unticked. It would be too time-consuming for us to individually select which customers we want to email statements to, we would like to be able to 'swap' then email the statement but for it to leave out any that do not have this box ticked. Can someone tell me what I'm doing wrong?
Also, is there any way I can generate a list of statements that have not been emailed to show us the ones that we need to print and post?
Thanks
0
Comments
-
Now resolved!0
-
Hi,
I'd love to know how you managed this. currently I do this one by one and it takes forever!!!0 -
Hi
I created a copy of the layout and named one Print and one Email then applied a filter to each (SALES_LEDGER.LETTERS_VIA_EMAIL<>1 / SALES_LEDGER.LETTERS_VIA_EMAIL<>0) so now I can select all customers and run both reports and only get the ones that I want.
I am having trouble with footers though. When I preview the report in sage it displays fine, but when I actually open the attachment from the email the page footer on the last page drops off. If you have any knowledge on this it will be gratefully received!
Gem0 -
Actually I've now discovered that it drops off one-page statements as well when opened from the email!0
-
Hiya, nice
Im simply having trouble with it outputting to emails currently across multiple customers. im liking some of the new changes in 2014 edition.
I see what youve done and its clever! anything to speed up debt chasing is always a bonus.
Thanks,0 -
Where do you use the filter? would that be the reason its pushing the report down? sorry stab in the dark but i'd say its a layout issue of the template but your way beyond my level of experience here0
-
can only suggest View > properties then under Export settings check all sections are ticked0
-
Hiya
I called Sage in the end and they advised not to use a page footer as it doesn't work properly! So instead I created a template which is just my letter head and applied this to my statement layout and fiddled with my margins to get it to display properly.
What problems are you having outputting to emails? Do you get an error message at all? When I first tried all of my statements were being emailed as one attachment to one customer until I changed the 'to' settings to group2 sales ledger email.
Hope this helps!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership