ब्लॉग कोशिश कर रहा है بلاگز کی ک*Trying Blogs

[DocAElstein]

Background testing work for this Thread:
http://www.excelfox.com/forum/showth...and-send-email
Also related to these Threads and Blogs

http://www.eileenslounge.com/viewtop...=29556#p228710
https://msdn.microsoft.com/en-us/lib...toSendingEMail
http://www.excelfox.com/forum/showth...0632#post10632
http://www.excelfox.com/forum/showth...once#post10518


< HTML HTM > coding
At least until recently, the “language” most commonly used or seen in Internet and World wide web electronic communication is the “pointy bracket” type,” ( Hypertext Markup Language https://en.wikipedia.org/wiki/HTML https://www.youtube.com/watch?v=1gLh...D6F7E289625976 “ ) , which to a large part of most such coding consist of pairs of “start” and “stop” “tags” in a long string to tell something about what is within the tags, like, pseudo code example

<AText>This might be a final text you might “see” in something like an Internet Browser which can “read” HTML coding</AText><nextInstruction>………

or, for convenience this often is seen in a “.html” file, if viewed in the code form, like

  <AText>
  This might be a final text you might “see”…….
  </AText>
<nextInstruction>………

( In a VBA code the last code string would be typically constructed something like this :

= “<AText>” & vbCrLf & “This might be a final text you might “ & “””” & “see” & “””” & ”…….” & vbCrLf & “</AText>” & “<nextInstruction> ….

Or this:

= “<AText>” & vbCrLf & “This might be a final text you might ““see””…….” & vbCrLf & “</AText>” & “<nextInstruction> ….

…….. )

The extra carriage returns and / or Line feeds (vbCr , vbLf , vbCrLf ) , in the total string, as in the last code form would typically be ignored by any
Various software is available which can read that HTML coding. The most commonly known thereof being the internet browsers most commonly available, such as Internet Explorer from Microsoft, or Google Chrome from Google. Basically an Internet Browsers main function is to receive and read the HTML coding which is typically passed in Internet and World wide web electronic communication
So basically , if that HTML file is “fed” to something, such as an internet browser, then you, as final user/observer, would finally see something like this:

___This might be a final text you might “see” in something like an Internet Browser which can “read” HTML coding

Here an example of Internet browser, Google Chrome, used for receiving Emails , using the Email provider software of gmail and German Telekom
SeenIngmailOrGermanTelekom.JPG : https://imgur.com/Oz6z6tq
SeenIngmailOrGermanTelekom.jpg

Using this language you can make many other things “appear” in addition to simple text.

Currently I am interested in extending the “seen” message developed in posts around here, gmailInputRunOnThursday7thJune bw table.JPG : https://imgur.com/Dh38G4O , to include some colouring and possibly heading information

So I have this:
gmailInputRunOnThursday7thJune bw table.JPG : https://imgur.com/Dh38G4O
gmailInputRunOnThursday7thJune bw table.JPG
But I want something more like this:

...... I wonder if we can include like the picture below.
Attachment 2061…

Equipment PM 2 .jpg
This is basically the Excel range format in the file from which the Information comes
Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K
1	Equipment PM
2	Machine EQ.ID	Manufacture	Model	Description	Serial Number	Weekly Date of Service	Weekly Next Service	Monthly Date of Service	Monthly Next Service	Quarterly Date of Service	Quarterly Next Service
3
4	1	JUKI	GKG GL	GL SCREEN PRINTER	A123	06.04.2018	13.04.2018	15.03.2018	12.04.2018	N/A	N/A
18	137	Juki	K3	Screen printer	A137	03.06.2018	10.06.2018	N/A	N/A	N/A	N/A
19	141	Heller	1826 MK5	Reflow Oven	A138	N/A	N/A	13.05.2018	10.06.2018	N/A	N/A
20	142	NISSAN	MCU-112A331.V	Forklift	A139	N/A	N/A	N/A	N/A	13.05.2018	10.06.2018
21	142	NISSAN/yearly oil change and lube	MCU-112A331.V	Forklift	A140	N/A	N/A	N/A	N/A	N/A	N/A
22											28.01.1900

Worksheet: Equipment PM

_.___________________

HTML tolerates many mistakes + Microsoft files can be saved as .htm/html type
Here are a couple of interesting and relevant observations:
_(i) It would appear the HTML coding is quite tolerant of mistakes or having additional code lines, or Tag pairs that it does not recognise. Sometimes a large amount of coding will be accepted, and only a small part will be read and used successfully to give a “seen” output.
_(ii) Microsoft Word and Microsoft Excel Files can be saved as .htm extension instead of the more common extensions ( .xls , .doc , .xlsx etc…

Because of these two things, it is possible to save a File in such a way, and then use that as the HTML coding used in the Email sending codes which are being discussed here , ( https://tinyurl.com/y8gxucsl , https://tinyurl.com/yacekv4o , http://www.excelfox.com/forum/showth...mail#post10670 , http://www.excelfox.com/forum/showth...once#post10518 )

So, pseudo code part like this would be used

     Dim strHTML As String: Let strHTML = The String of HTML coding obtained from a saved as .htm Word or Excel File
    .htmlbody = strHTML

Such a technique is often done. Sometimes only a part of an Excel spreadsheet is wanted and this can also be saved in a .htm extension.
When using this technique, a lot of extra HTML coding is present which is not needed or recognised when used for the sent Email. As noted, this does not normally cause problems.
( often this technique goes by the name of Publishing or range publishing )
I personally prefer to examine the HTML coding and pick out only the information I need. This is the way I personally prefer to do it

In the next post I will look at this last way of doing things. I will use the example of the required ….. “….I wonder if we can include like the picture below ….”……

...... I wonder if we can include like the picture below.
Attachment 2061…