Hi Kirk,

On Mon, Jul 22, 2019 at 11:26 PM rooftop99--- via 4D_Tech <
[email protected]> wrote:

> Our marketing department is creating eMails in Outlook which included
> images, hyperlinks (text and image), backgrounds, etc.  We would like to
> take these emails and copy the body content into a field in 4D to be
> retrieved for future email campaigns sent from 4D. The links, images and
> formatting need to be maintained.


> I have looked at 4D Write Pro as an option but it doesn’t appear to accept
> the entire contents of an outlook email via paste and it is expensive.


First, you don't say but I assume the emails are formatted HTML. The
"entire contents of an outlook email" is a .eml file, or Microsoft's
interpretation of one, and Write may be able to work with it.

I would take the email text, and that's all it is - a big block of text -
and extract the HTML. You'll have to inspect the actual text but I expect
you can find something that starts with "<html>" and ends with "</html>".
Pull that out and store it in a text field or whatever. That content should
display as you want in a web area. You may get different results using the
internal web kit vs. not.

The html may not be so neatly identified but the principle is the same,
find the html part, extract it, wrap it in your own <html></html> tags if
you need to and display in a web area. That's all something that could be
automated, I think. Set up a mailbox for the server, if it doesn't have one
already, and have marketing include it in the mailings. Server checks the
box now and then, downloads the marketing email and creates the record for
it. You probably have that in place already, I suppose.

If the emails aren't html for some reason it will be extremely difficult to
match formatting and such. But I really doubt that's the case.

-- 
Kirk Brooks
San Francisco, CA
=======================

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to