12-02-2011 12:27 PM
I'm sending a custom generated order confirmation via email to a contact with a cc to the account manager.
The email message opens in the editor, with all of the fileds properly populated, just no attachment.
Message editor is Outlook 2010
Sales Logix is SLX LAN Client 7.5.4.7048
Here is the code which right now is triggered from a button click on a form. attachment path is a paramter and the value I'm passin is valid.
Sub SendEmail(attachmentPath) stop dim emailSQL 'get the email address of the account manager emailSQL = "SELECT EMAIL FROM sysdba.USERINFO WHERE USERID = '" & lveacctmgr.Text & "'" dim acctMgrEmail acctMgrEmail = GetStringFromSQLSatement(emailSQL) 'get the email address of the contact emailSQL = "SELECT EMAIL FROM sysdba.CONTACT WHERE CONTACTID = '" & lvebillcontact.LookupID & "'" dim contactEmail contactEmail = GetStringFromSQLSatement(emailSQL) 'use the path of the newly created attachment Application.BasicFunctions.QueMessage contactEmail, acctMgrEmail, "", "Confirmation for Order #" & txtQDBQuoteNumber.Text, "", attachmentPath End Sub
Solved! Go to Solution.
12-02-2011 01:04 PM
12-02-2011 01:09 PM
From the dev reference
Parameters
ToAddress
To Address for the e- mail contactEmail
CCAddress
CC Address for the e-mail acctMgrEmail
BCCAddress
BCCAddress for the e-mail ""
Subject
Subject for the e-mail "Confirmation for Order #" & txtQDBQuoteNumber.Text
Body
Body of the e-mail ""
Attach
Attachment path for the e-mail attachmentPath
I would like to think that invalid parameter count would throw an error, but a nice thought, unless the order of the parameters ahs changed....
12-02-2011 01:14 PM
12-02-2011 01:20 PM
The path currently is a local file for development
"C:\testoutput\2001003-1\OrderDetails20111521.pdf"
I can attach this once the editor is open
Is there a setting in Outlook 2010 that would prevent other application for automatically attaching items?? I'm no outlook expert.
I'm not sure what you mean by (do you have acces to another email client vsn)?
I am creating the order confirmation using a .Net Extension but the System.Net.Mail is even more challenging for attachments. I also want an editor to display so our Customer Service reps can customize the message. I'd rather not have to create a form to do all of that when an email editor is readily acessible.
The code above is dev only just to get things working.
12-02-2011 01:32 PM
12-08-2011 12:41 PM
Are there any known issues with this method and outlook versions past 2003??
12-08-2011 03:44 PM
12-14-2011 02:56 PM
Ok, I figured it out.
This may be basic, but if it helps anyone else out there...
In Administrator on the Client System tab. The Mail System needs to be set to “Microsoft Outlook”. If set to None, the attachments won’t work.
It's working now.