The Book-keepers Forum (BKF)

Post Info TOPIC: Sage 50 - Email Statements


Guru

Status: Offline
Posts: 771
Date:
Sage 50 - Email Statements
Permalink Closed


Hi

I have a client who I do the bookkeeping for, then on a weekly basis send them the Sage data file to restore onto their copy of Sage so that they can carry out the credit control.

Because of the every increasing costs of postage, paper etc they are looking to send the customer statement by email. 

I am used to setting this up and it running from Outlook but they are using an internet based account (Windows Live I think).

So can they send the statements out from Sage through this account and if so how do you set it up

Thanks

Mark



__________________

M & G Associates

Website www.mgassociates-accountancy-services.co.uk/

Accountancy Services Plymouth, Bookkeeping Payroll Sage Training

 



Senior Member

Status: Offline
Posts: 111
Date:
Permalink Closed

Go into the customer record and put their email address in and tick the box to say you want to email statements

__________________


Guru

Status: Offline
Posts: 771
Date:
Permalink Closed

Hi Gilly

Sorry, like I said I know how to set them up to send statements by putting the email address in the details, ticking the box and then using the email option from within statements but I want to find out is how it works when using a internet email account as opposed to Outlook, because when I use Outlook and send them they are just automatically output to email.

Thanks

Mark


__________________

M & G Associates

Website www.mgassociates-accountancy-services.co.uk/

Accountancy Services Plymouth, Bookkeeping Payroll Sage Training

 



Senior Member

Status: Offline
Posts: 111
Date:
Permalink Closed

Sorry. I didn't read the question properly. Most of the time when I read and respond on this site is when I'm on a train and the connection is usually slow and I've forgotten the question by the time it's loaded the answer screen !! Age gets us all in the end. I'll have a fiddle with it and see if I can work out how to do it

__________________


Newbie

Status: Offline
Posts: 1
Date:
Permalink Closed

Earlier this year I made the decision to drop Outlook and switch to gmail. I had a similar problem when trying to email from programs. I found a program called gmail notifier pro which overcame these issues. The same program is advertised as working with Microsoft Live Mail. You could perhaps take a look at that if you are still trying to find a solution.
Tim

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Setting up Sage 50 to send stuff out by email (and not using Outlook) is relatively painless.

The first thing you should do is tell Sage your own email address - although this is one of Sage's little sillies (especially for a multi-company set up) but don't worry about that for the moment. This is set by going to Settings on the top menu => Company Preferences, and entering the email address you wish to use in the Email box on the Details tab.

That was the easy bit.

Next up, Sage needs to know how to send the email - your outgoing (SMTP) server details. This is done from within the report generator. Since you're wanting to send statements by email, you may as well go in through the statements screen, and select the statement that you are going to use when emailing statements. Select it, and click on Edit.

When the report generator comes up, on the menu bar click on Tools => Options and go to the Email Setup tab. Change the default provider to SMTP.

In the "Available Providers" box below that, click on "SMTP" and then "Configure" and you'll get a window called "SMTP Configuration" in which you enter all the necessary information:

Server Name is the name of your outgoing mail server (which you should have set up somewhere in your email program in order to send email).

Port will normally be 25

Under Sender details you need to enter the email address (yes, the one you've already set up in the main program) and the name that will be used along with it (or a post title, like "Bookkeeper" etc)

Finally, there are the log-in details for your outgoing mail server, which will typically require that you select "Use username and password" and enter the, erm, user name and password used to log-in to the outgoing server.

Click "Ok" to close the window, and then (if you like) click "Test" in the Options window: You'll be prompted to enter an address to which a test email can be sent. If that test email is received at that address, you'll know it's working, so the Options window can be Okayed to close it.

Now, for the statement you wish to send by email, you may need to tweak some items in the email properties. If the properties aren't showing, click on View => Properties. Somewhere in the list that appears will be an field called Email properties; click on that to open the report-specific email stuff.

If it's a report that's already set up for email, some stuff will already be filled in - such as the "To" field, which should contail the SALESLEDGER.EMAIL variable.

From can be set to contain the from name and email address - eg "Fred Bloggs" which will pick the address up from the main program's company settings.

(Only a couple of versions back, either this field wasn't there or there was no variable - I forget the exact situation - so it would only use the address set up in the report generator email settings, and if you were running a multi-company version of Sage, so had a different email address for each company, the report generator settings were "one size fits all". That meant it would only ever use the one address, no matter which company you were sending from.)

Above From is CC, and I always send a copy of any reports like statements to the company email address. I started doing that after I encountered an incredibly stupid bug in the way Sage handles email a couple of years ago, which they've subsequently "fixed" - in quotes, because when I reported the bug to them, the support drone vocalised a possible fix on the phone to me that made me want to facepalm.

You can also change the subject line to something more meaninful than the default.

Below that, you specifiy the format the report is to be sent in - I usually opt for PDF - and below that, you can specify the filename.

Finally, the bottom box allows you to specify the way the statement is to be sent; set it to send immediately, by SMTP.

Okay that, save the report.

In theory, you should now be able to send statements by email.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Member

Status: Offline
Posts: 23
Date:
Permalink Closed

Just been wandering through, and found this, which is of great interest to me.

I've been trying to set it up, but having trouble with my outgoing mail server, tbh, they are generally a mystery to me...

If I'm using BT Internet, where will I find these details?

If I put in BT Yahoo, then the test to send the e mail fails.

Any clues guys?


__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Unfortunately, knowing where things are set up in Sage is one thing - but knowing the specific settings for any given email provider/ISP is quite another.

Your starting point are the settings in your email program for outgoing sever, which might be something like smtp.btinernet.com, with your email address as a username and your password as the password - but then again, they might be something entirely different to that. If in doubt, speak to whoever set up your email access, or perhaps speak to BT Internet themselves.

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About