Emailing and Posting Invoices

[brucedenney]

Your expressions are the wrong ones for each type

[Tda321]

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

[doinktheclown]

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

[brucedenney]

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

[doinktheclown]

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

[brucedenney]

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.

[doinktheclown]

Brilliant! Thanks very much Bruce.