The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
QueMessage with Attachment
Posted: 04 Sep 08 3:04 PM
|
Trying to add an attachment to the QueMessage Call. Have tried several ways to include the following which is similiar to the Attachment Support in a SLX 7 database.
Dim Shell
Dim ShellEnv
Dim strAttach
Dim FSO
Set FSO = CreateObject("Scripting.FileSystemObject") 'DNL
Set Shell = CreateObject("WScript.Shell") 'DNL
Set ShellEnv = Shell.Environment("PROCESS") 'DNL
strAttach = FSO.GetFolder(ShellEnv("TEMP")) & "\" & "ABC" 'DNL
FSO.CopyFile strAttachment, strAttach
Application.BasicFunctions.QueMessage strEmail, strCCEmail, "", strSubject, strHTMLBody, strAttach
FSO.DeleteFile(strAttach)
Set Shell = Nothing
Set ShellEnv = Nothing
Set FSO = Nothing
Where I copy the desired file into a dummy file named "ABC". The Outlook email pops with desired email addresses and body but no file attached. I have tried UNC file structure along with Saleslogix Attachments. I would like to pull one file off the drive and email it out.
Does the email body support HTML formatting. I have the tags but it seems to be straight text going out. Just a side note.
Your direction will be greatly appreciated.
Sherri
|
|
|
|
Re: QueMessage with Attachment
Posted: 04 Sep 08 3:21 PM
|
How about ABC.txt instead of ABC?
It has been awhile (2004) but we used to do this all of the time..... |
|
|
|
Re: QueMessage with Attachment
Posted: 04 Sep 08 5:47 PM
|
Did not matter what the name was. I have used GIF, JPG, PDF, and DOC and none of them were attached. I tried copying it and do it straight from the drive, as well. Thanks for the suggestion. Sherri
|
|
|
| |
|
Re: QueMessage with Attachment
Posted: 05 Sep 08 6:55 AM
|
| I beleive that the issue is that BasicFunctions.QueMessage basically invokes a MailTo: command, which does not actually support attachments. It's not really a SLX issue. You will find many people perplexed by MailTo and attachments if you google it, because it doesn't pop an error, but it doesn't support it either. |
|
|
| |
|
Re: QueMessage with Attachment
Posted: 05 Sep 08 10:56 AM
|
I have heard of examples of the QueMessage working for attachments but its just not working in my case. Which makes me think that it might be an Outlook version issue. Currently on Outlook Express version 6. Does anyone know if there is an incompatibility issue between Outlook Express v 6 and this QueMessage?
Your replies are much appreciated.
Sherri
|
|
|
|
Re: QueMessage with Attachment
Posted: 06 Sep 08 7:11 AM
|
Originally posted by Sherri Waite
I have heard of examples of the QueMessage working for attachments but its just not working in my case. Which makes me think that it might be an Outlook version issue. Currently on Outlook Express version 6. Does anyone know if there is an incompatibility issue between Outlook Express v 6 and this QueMessage?
Your replies are much appreciated.
Sherri
|
|
Sherri,
I believe you answered your own question:
Outlook Express
SalesLogix is "friendly" with "full" Outlook but guarenteed to work with Express.... |
|
|
|
Re: QueMessage with Attachment
Posted: 08 Sep 08 12:17 PM
|
But.... I get the same results with Outlook 2003. HHMMM. No attachment and no HTML. And when I say attachment, I am talking a PDF file from the drive and not a Saleslogix attachment. Still working it. Thanks for your help.
Thanks again,
Sherri
|
|
|
|
Re: QueMessage with Attachment
Posted: 08 Sep 08 6:29 PM
|
Just ran a few tests:
A - Searched the entire OOTB plugin table.. SalesLogix does NOT use the Attachment "argument" anywhere. So there is NO working example available.
B - Ran a test myself and it just does not work... looks like a bug to me. |
|
|
|
Re: QueMessage with Attachment
Posted: 09 Sep 08 2:47 AM
|
I created this code snippet when writing DevLogix:
Dim ToAddress, CC, BCC, Subject, Body, Attach
ToAddress = "john@abbott.demo"
CC = ""
BCC = ""
Subject = "Information Request"
Body = "Hi John" & chr(13) & chr(13) & "Info attached"
Attach = "C:\Temp\Test.txt"
Application.BasicFunctions.QueMessage _
ToAddress, CC, BCC, Subject, Body, Attach
And it worked at the time (there is a screenshot!)
Can't test it right now though.
BTW, if you are using Outlook Express then you can use the SalesLogix Mail Client configured for MAPI to sent emails - you do get lots of security warnings though.
Stephen
|
|
|
| |
|
Re: QueMessage with Attachment
Posted: 09 Sep 08 7:39 AM
|
I just ran a NEW set of tests and it worked fine.
Here's how to NOT have it work:
1 - use OE - does not seem to work here
2 - make sure Outlook is the Default Email system and it's fully configured in SalesLogix
Here's the "code" IO used:
Sub SendmailOC(Sender)
Dim bRetVal
bRetVal = Application.BasicFunction.QueMessage("RJL@whatever.com","","","Test","Hello","c:\TheToolBoxX.sxb")
End Sub
|
|
|
|
Re: QueMessage with Attachment
Posted: 18 Sep 08 11:08 AM
|
I went with the COM object for not only the attachment but to be able to do HTML in the email body. Ultimately, we wanted to insert a JPG into the email body and the Outlook signature and I was able to accomplish that using the COM.
Thank you again to everyone for their suggestions.
Sherri |
|
|
|
Re: QueMessage with Attachment
Posted: 19 Sep 08 9:23 AM
|
Sherri, glad to hear you got it to work. I am guessing the following was your issue:
The queuemessage operation will only add an attachment if you have SalesLogix configured to work with the Outlook profile installed on the machine. This is done through Tools...Options menu in the client. If you do not have this configured, you will get an email dialog to open but no file will be attached. |
|
|
|
Re: QueMessage with Attachment
Posted: 16 Nov 09 9:54 AM
|
Hi all, I use
Application.BasicFunctions.QueMessage "asdasd","asdasd","asdasdasd","test","asdasdad","C:\sleep.js"
with LotusNotes, the mail is created but without attachments 
What is the problem? |
|
|
|
Re: QueMessage with Attachment
Posted: 16 Nov 09 11:27 AM
|
Does QueMessage and attachments work with Lotus Notes?
we use Linkpoint 360 and/or direct manipulation of Notes objects in vbscript....and use attachments. this has been working for awhile, current version of notes is 8.
|
|
|
|