Email formatting

galland1928 · 2008-01-30

We are running Lanham E-ship which has support for emailing PO's, SO's, etc. The only problem is that we can only send emails in "Plain Text" format so email's don't look very nice.

Are there any other modules for Navision 4.x that support sending emails in HTML format?

Any help is greatly appreciated!
Thank you

tinoruijs · 2008-01-30

I don't know if it is sufficient, but you could use Preview of reports and use "Report by E-mail" (menu File, Send).

It uses Outlook in which off course you can send emails in HTML-format.

Savatage · 2008-01-30

I'm working on a similar project.

As far as links & email address go - they are clickable in the email
like : http://www.mibuso.com/forum/viewtopic.php?t=23592
actually work.

My next step is to see if I can send a picture or a company logo in the email.

The things I will be looking into are codeunits:
14000902 - Generate E-Mail Field Value
14000904 - E-Mail Get Field Value

First I'll start off just to see I can make something BOLD!
-Can't define BLOB's in codeunits - there go's my idea of adding picture..hmmm :-k

PS if you have any documentation of the lanham emails - I'd like to have them.

Savatage · 2008-01-30

After some further review - Report #14000903 (Which is the Sales invoice Email) as an example has documentation that states:

Documentation()
The Code that customize the running of the report should be done in the 4 triggers
GetInitialRecords
This is where all the values needed for the general information in the E-Mail are retrived.
Additional tables could be added in the information was needed.

ModifyRecords
This is the final step, where the status of some records are modified. This could be used to
change a field telling that the E-Mail has been sent.

GetFirstRecordInLoop
This will get the first record in each level. This also adjust some variables and contol that the
flow of multilevel tables are correct. Like the printing of Posted Package/Posted Package Line.

GetNextRecordInLoop
This will retrieve the next record for each level.

SaveReportAsHTML
This will run and save a specific report as HTML

Savatage · 2008-01-30

There no place for, that I can see properties like..
FontSize=12;
FontBold=Yes;
FontItalic=No;

Anyone have connections with anyone at Lanham? Perhaps they can clear this up real quick without us having to mess around trying stuff
[-o<

Let's link these two together.
http://www.mibuso.com/forum/viewtopic.php?t=5745
See last post..I asked about formatting back in August ](*,)

galland1928 · 2008-01-31

Tinoruijs,
Unfortunately we want to automate the sending of these emails so that wouldn't really work for us.

Harry,
Looks like you have been working on this issue for a while and have the same problems as us.

It seems like the first part of the problem is that emails are only generated in "Plain Text" format so no bold, italic, pictures, or different font sizes are available as an option.

Do you know if the mailOCX deals with the formatting or if the codeunit does?

Thanks for the tip on codeunit 14000903.

Has anyone else worked with Lanham E-ship?

Savatage · 2008-02-14

I just ent an email to Lanham

At this point I'll take any insight.

PS. If while in the Email creation form - Email->attachments.

you can add a set attachment
Type: Fixed File
Fixed File Name: C:MyPicture.jpg

I can add some picture of a banner and things like that but embedded would be much better than attached. But alteast in an email Preview screen the pic does show.

My goal is to have the nice banner on top and the email nfo follow afterward. I tried creating a custom Stationary but the email is created inside Nav and the stationary never gets accessed. So that doesn't work.

Savatage · 2008-02-14

Tried adding <IMG SRC="File:///c:/MyPicture.jpg"> to the one of the email lines. the email sends but no pic shows and the link works if you click it but that's no good too.

Savatage · 2008-02-14

Tip: We use this for emailing hundreds of emails. But it's default setup doesn't really allow for this. You have to enter the email Addresses in the customers/vendors email setup list.

Since we import our orders from an outside source - we use one customer number and keep changing the ship-to addresses. All does thru dataport. So to send an email to all these individual people just add an "E-Mail" field to the sales header & sales invoice header (same #) This field get populated with the import of all the orders.

one E-Ship Report 14000903 Sales invoice Email. Add

Right After// Address The Mail

// Add Individual Email Possibility
IF SalesInvoiceHeader."E-Mail" <> '' 
THEN
      MailOCX.AddReceiverTo(SalesInvoiceHeader."E-Mail")
ELSE
// End Individual EMail Possibility
REPEAT
.
.

The report will bypass the EmailEntryList and send the email to the address on the order.

Savatage · 2008-02-15

Lanhams offical response is:

At this time the product does not do that and we do not have any
suggestions on how to make that happen. I am sorry for the
inconvenience

I guess we're on our own.

Mini · 2008-03-26

Hi Guys,

I am using the SMTPMAIL OCX for sending the emails. I am writing the heading and deatils in the mail. Eg.

Doc Type Doc No Amount
Invoice PI001 1000

I want to keep the same space between the headings and details. Can any body tell me if I can use tab or someting else for formatting the email.

Your reponse will be appricated.

Thanks
Mini [/quote]

Email formatting

Comments

Categories