Emailing to Lotus Notes 1

[SamuelBiddulph]

I have a Filemaker 6.0 database that it set up to send an e-mail via Lotus Notes when a button is pressed. This works fine expect for one problem. Text that appears in the body of the mail is one continuous line and i cannot get line breaks/carrige returns in the body text. Even if you physically put returns into the piece of text to display the body, these are not reflected in the e-mail output.
The text in the body is a combination of static text and the contents of several fields, these are all put together when the script for sending the e-mail is processed.

Any ideas?

 

[lebisol]

hm ..I dont know about Lotus Notes but I know about FM:

http://www.MOSTARnet.com/tutorials/filemaker/SendEmail.zip

All the best!

> need more info?
:: don't click HERE ::

 

[SamuelBiddulph]

Unfortunatly the example you provided interfaces with Outlook which i don't want to use as our corporiate e-mail system is Notes.
Thanks for your try though

 

[jaco8867]

I have a filemaker 6.0 database sending e-mail via Lotus Notes. Are you putting line breaks characters in or are just putting line breaks in the script/calculation?
for example:
"Line1 Text" & "¶" & "Line2 Text"
NOT:
"Line1 Text
Line2 Text"
(I hope that makes sense)

Are you using a calculation or script to get the body text? I use a calculation to piece together the body text then a script that grabs that calc. Field for the body text.

 

[SamuelBiddulph]

I've actually tried both and get the same output (no line breaks). I'm running a script that constructs the mail to send to Lotus Notes.
Below is a copy of the script that i'm running at the moment. There are no line breaks in it of any form as i tried your methods but got the same output.


Set Field [ Send To, &quot;TO &quot; & Name & <@XXXXXXXXXX.COM&quot; ]
Set Field [ CC, &quot;CC &quot; & &quot;<MY EMAIL ADDRESS OMITTED&quot; ]
Set Field [ Subject, &quot;SUBJECT &quot; & &quot;VanderLande IT Support Ref: &quot; & PK_ID ]
Set Field [ Text, &quot;TEXT &quot; & &quot;Your call regarding: &quot; & IssueDescription & &quot; has been logged. If you wish to contact Samuel Biddulph regarding this issue please quote call reference number: &quot; & PK_ID & &quot;.&quot; ]
Send Message [ Event Specification: Program: Application, Event Class: aevt, Event ID: odoc, Filename: &quot;notes.exe&quot; ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: &quot;NewMessage&quot; ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Send To ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: CC ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Subject ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Text ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: &quot;SEND&quot; ]
Insert Text [ Status, &quot;Acknowledged&quot; ]
[ Select entire contents ]
Go to Layout [ Menu : UK-IT ]
[ Refresh window ]

 

[jaco8867]

I'll recreate your script and see what results I can come up with.

The sendmail example that lebisol gave above does work with Lotus Notes. The only issue is the that the user has to hit send in Notes.

 

[jaco8867]

There is three methods that can be used.

1) Instead of a line break/return you need to send a ASCII line-feed character. If i recall line-feed is character code 10.

2) Separate your TEXT commands into separate lines.
For Example
Set Field [ Text1, &quot;TEXT &quot; & &quot;Line1 Text&quot;]
Set Field [ Text2, &quot;TEXT &quot; & &quot;Line2 Text&quot;]
.
.
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Text1 ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Text2 ]

3) Use the PASTE command instead of TEXT.
For Example (*Using your Script*)
Set Field [ Send To, &quot;TO &quot; & Name & <@XXXXXXXXXX.COM&quot; ]
Set Field [ CC, &quot;CC &quot; & &quot;<MY EMAIL ADDRESS OMITTED&quot; ]
Set Field [ Subject, &quot;SUBJECT &quot; & &quot;VanderLande IT Support Ref: &quot; & PK_ID ]
Set Field [ Text, &quot;TEXT &quot; & &quot;Your call regarding: &quot; & IssueDescription & &quot; has been logged. If you wish to contact Samuel Biddulph regarding this issue please quote call reference number: &quot; & PK_ID & &quot;.&quot; ]
Send Message [ Event Specification: Program: Application, Event Class: aevt, Event ID: odoc, Filename: &quot;notes.exe&quot; ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: &quot;NewMessage&quot; ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Send To ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: CC ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: Subject ]
Copy [Text]
[Select entire contents]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: &quot;Paste&quot; ]
Send DDE Execute [ Service Name: &quot;Notes&quot;, Topic: &quot;SendMail&quot;, Commands: &quot;SEND&quot; ]
Insert Text [ Status, &quot;Acknowledged&quot; ]
[ Select entire contents ]
Go to Layout [ Menu : UK-IT ]
[ Refresh window ]

 

[SamuelBiddulph]

Thanks for your input, for what i want to do (and for the future), method 3 would be the best. I've implemented the changes to my scrip but when i click to send and notes begins to process the data passed to it i get an error saying it can't copy the data that is on the clipboard. Clicking ok to carry on does send the e-mail but without any body text.
Any suggestions?

 

[jaco8867]

The field your copying (TEXT) must be on the layout. either add it to your layout, or in the script switch to another layout that includes that field then switch back to your orignial layout.

Sorry about that, I had that problem to and forgot to mention it.

 

[SamuelBiddulph]

Thanks - It's working great.

 

[SamuelBiddulph]

Somewhat related to the origional question. Is it possible to pass formatting commands within the text that is to become the main body of the email, such as bold, font size and type? So far i've come up with nothing.

Any help would be great

 

[jaco8867]

Unfortunately, I don't know of a way to make it work either.