have you tried escaping your line breaks with a backslash? not sure if that would help.
Also for your attachment, have you tried adding your file to a global container field and attaching it as a field, also I usually calc my paths like: "file:" & get(temporarypath) & "test.pdf"
This is copied from the Functions explanation:
Notes about file paths : The paths used by the plugin are Operating System paths, not FileMaker paths. To get an example of the sorts of paths required, use the BE_SelectFile function, and choose a file with a known path.
Caught me a few times too, but it should solve the attachment issue
Brilliant. That worked. Here is what I did to strip the path down:
Substitute(Get(TemporaryPath)&$FileName; Get(SystemDrive) ; "")
I had to get rid of the drive name before it would work.
Still have the issue of carriage returns.
Thanks Mike for the suggestions. Neither seemed to do the trick, but the path thing was definitely in the right direction.
1. If you plan to use BE regularly, best write a Custom Function to convert between paths formats.
2. Don't know if it works with BE anyway, but what you meant in your original post was probably Char(10) | Char(13), rather than Code(10) | Code(13)
--2. Don't know if it works with BE anyway, but what you meant in your original post was probably Char(10) | Char(13), rather than Code(10) | Code(13)
That's it! I confused the two. Char(10) works. Thanks all. Problems solved.