11/26/2024 4:25:41 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum for off topic and general discussion. View the code of conduct for posting guidelines.
|
|
|
|
EMail merge
Posted: 03 Oct 06 10:11 AM
|
fiogf49gjkf0d I want to send HTML emails to several contacts. Is anyone doing this out of SLX? If so how? I create a template, but have to include a merge field (that I don't need) or I get an error. I have a work around, but wonder if there's a better way. |
|
|
|
Re: EMail merge
Posted: 04 Oct 06 2:32 AM
|
fiogf49gjkf0d Hi Brandy,
I have some code for you. Hope this is what you are looking for.
'Get Rep. Name
strSQL = "SELECT FIRSTNAME,LASTNAME FROM USERINFO U " _
& "WHERE USERID = '" & Application.BasicFunctions.CurrentUserID & "'"
Set objCon = Application.GetNewConnection
Set objRS = objCon.Execute(strSQL)
If Not objRS.EOF Then
strRepName = objRS.Fields(1).Value & ", " & objRS.Fields(0).Value
End If
objRS.Close
Set objRS = Nothing
Set objCon = Nothing
' Get Order Number
strOrderID = grdOrders.GetCurrentField("OrderNumber")
strTo = put mail address of contact person
'Body of the Email.
strBody = "Please send a Call Tag to " & Application.BasicFunctions.CurrentAccountName & " for Order Number # " & strOrderID & "." & vbCRLF
strBody = strBody & vbCRLF
strBody = strBody & "Thanks for your help, " & vbCRLF
strBody = strBody & strRepName
Call SendEMail
' Procedure to send mail
Sub SendEmail
Set objOutlook = CreateObject("Outlook.Application")
Set objMailItem = objOutlook.CreateItem(0)
objMailItem.Display False
objMailItem.Body = strBody
objMailItem.Subject = "Call Tag Request for Order Number # " & strOrderID
objMailItem.To = strTo
objMailItem.CC = put mail addresses here for another contact persons.
'Clear Outlook Objects
Set objOutlook = Nothing
Set objMailItem = Nothing
End Sub |
|
|
|
Re: EMail merge
Posted: 04 Oct 06 8:40 AM
|
fiogf49gjkf0d I am not understanding what this code is. Where do i use it and what does it do? |
|
|
|
Re: EMail merge
Posted: 04 Oct 06 10:44 PM
|
fiogf49gjkf0d This is code what you are looking for to send mails. In this code you can find procedure called "SendEMail" which is used to send mail.
|
|
|
|
Re: EMail merge
Posted: 05 Oct 06 8:06 AM
|
fiogf49gjkf0d ...have to include a merge field (that I don't need) or I get an error. I have a work around, but wonder if there's a better way.
Sorry, there is no workaround. We do send HTML emails via SLX, but recently we started using Swiftpage for our email campaigns. We don't use it for confirmations or things we don't want to track.
As for the workaround, what we did here was add the contact.userfield5 field as a mail merge field to the template at the end. This field is a custom field and we are not using it. So its not going to have any kind of data in it.
As for HTML in the template editor - which is Word. We've found Word can be picky, especially if you try creating an HTML web page outside of Word then copy and paste it into the Word template editor. Might look fine but when you send an email test of it it might look different in places (fonts, table data, etc)
All in all, using word as a template editor is sufficient for the easier kind of emails. But the more you want to put into it the more issues are likely to appear. This was one major reason for us going to Swiftpage. Plus the bonus was that we get to see results of the email campaigns we send through it - like nmber of opens and what links were clicked.
John G. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|