SageForum for UK versions of Sage 50- Help and support.

Your expressions are the wrong ones for each type

Sage was crashing when 'Email' was pressed and reports were being exported to customers with email addresses rather than without.

However, I figured out that this was because out mail provider was down as 'Outlook' and needed to be 'MAPI' for anyone else reading this who suffers the same 'SBDDesktop.exe has stopped working' issue.

I have just done out first ever successful email/post invoice run.

Thank you for your help Bruce, it's a great forum that you run here.

Tim

Got it set up, thank you.

Just one thing - does the body of the emails have to be plain text? I can change it in Outlook to HTML of course, but can it be set up to be placed into Outlook as HTML rather than plain text?

Thank you

There is no option to use HTML or insert variables in the boy of the message.

Eh well, no big issue.

Sorry to bombard you with questions but:

When sending for example an invoice to Outlook, is there a way to set the invoice number to appear in the email subject?
For example, I currently have it set as Company Name - Invoice, but is it possible to have it set to appear as Company Name - Invoice XXXXX?

Thanks for your help

Yes, you can use and expression in the Subject Field to do this the number needs converting to text with the cstring() function so something like..

COMPANY.NAME + " "+INVOICE.INVOICE_OR_CREDIT+ " No "+ CString(INVOICE.INVOICE_NUMBER)

Would result in the Company Name (as stored in settings in Settings), a space, the text for the type of invoice (ProForma,Quote,CreditNote,Invoice) then a Space then No then a Space and then the Invoice Number converted into a string.

Brilliant! Thanks very much Bruce.