My Journal

So with my school database that generates a word document for Final Report for students, it hit a wall with narrative/comments from teachers that's over 255 characters long. Instead of complaining long winded commentaries, I just had to fix this.

The best solution page, that is thorough enough, I am pasting its content here, lest it's taken down: (I basically just used ActiveDocument.Bookmarks("Bookmark1").Range.Text Instead of .FormFields("Bookmark1").Result.

Lynn,

I think if you have a better understanding of what's happening in Word
you'll be better able to come up with an acceptable solution.

First, you are correct that the character limit for formfields is 255. In
addition, you can set the .Result property of a formfield without removing
the protection from the document using something like:

ActiveDocument.FormFields("Text1").Result = "This is a string of less than
255 characters."

This is the basic nature of forms protection: the only place you can add
content to the forms-protected sections of the document is the formfields
within the section.

However, as you have found, if the content to be added exceeds the 255
character limit, setting the .Result property of the formfield doesn't work.
In this instance, you have a few options available to you. You can:

* Use the Trim function to truncate the string at 255 characters. This is
probably not an acceptable solution since you undoubtedly want the whole
string to appear in your document.

* Use multiple formfields and the Mid function to parse the string into
255 character "chunks", which then get inserted into various formfields using
the .Result property as described above. Again, this is a less-than-optimum
solution because it's clunky and may not produce an especially attractive
result.

* Use a bookmark and something like the following to insert the text:

ActiveDocument.Bookmarks("Bookmark1").Range.Text = "A long string of more
than 255 characters."

However, as you have discovered, this method requires the section containing
the bookmark to be unprotected (for the reasons discussed above), and you
have stated that making this section unprotected is not an option.

The best solution is to unprotect the document prior to inserting the text
and then reprotecting it again afterwards. The code for doing this would look
something like:

ActiveDocument.Unprotect "password"
ActiveDocument.Bookmarks("Bookmark1").Range.Text = "A long string of more
than 255 characters."
ActiveDocument.Protect wdAllowOnlyFormFields, True, "password"

(See the Word VBA help topics on document protection for more information on
this code.)

Only one thing concerns me: You say that you are "pushing" data from Excel
into Word. This makes me think that you are driving this process from the
Excel side rather than from Word. I'm not quite sure if you will be
successful in trying to unprotect a Word document using code from within
Excel. This being the Word VBA forum, I suspect that most contributors would
take the approach of "pulling" data from Excel using code in Word - and thus
would not have to worry about this potential problem. However, some of us do
"cross over" so maybe someone else will be able to help you with this
possible sticking point. Otherwise, I can only suggest that you ask the
question in the Excel VBA forum.
--
Cheers!
Gordon

Looks like there's a hole in the soffit near the mudroom. Critters/birds? movement could be heard in the mudroom on the ceiling sometimes.

I went out from the master bedroom's window all the way to the roof of the mudroom, measured 8"x24" hole that I need to patch.

Will go to home depot soon.

First of all, to preview word/excel, etc. in Outlook, the Office apps must be all in the same version, so said google.

Solution: Now, for PDF preview, Office/Outlook does not provide this, it's said to be provided by Adobe. Therefore, Adobe reader and Outlook must be in the same bit. (32bit or 64bit).

Solution source: https://support.microsoft.com/en-us/office/outlook-pdf-preview-error-this-file-cannot-be-previewed-because-there-is-no-previewer-installed-for-it-b78bfe24-ba13-44bd-8289-1919ece7ded2

Of course, nothing can escape Snipping Tool screenshot.

But what about the shortest way to convert to a pdf document file? Because Google Drive somehow, giving the ability to restrict viewers from downloading if the owner so chooses, convert the pdf into some partly encoded html format such that the printing will be blank.

The solution I've seen so far is from this site. Using JavaScript, we can play with rendering picture/text.

Basically injecting a JS code (ctrl+shift+c) in console, which I will paste below. After hitting Enter and closing the console window, the Save As dialog box shows up and the pdf file saved is not bad.

JS Code:

let jspdf = document.createElement("script");
jspdf.onload = function () {
let pdf = new jsPDF();
let elements = document.getElementsByTagName("img");
for (let i in elements) {
let img = elements[i];
console.log("add img ", img);
if (!/^blob:/.test(img.src)) {
console.log("invalid src");
continue;
}
let can = document.createElement('canvas');
let con = can.getContext("2d");
can.width = img.width;
can.height = img.height;
con.drawImage(img, 0, 0, img.width, img.height);
let imgData = can.toDataURL("image/jpeg", 1.0);
pdf.addImage(imgData, 'JPEG', 0, 0);
pdf.addPage();
}
pdf.save("download.pdf");
};
jspdf.src = 'https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.5.3/jspdf.debug.js';
document.body.appendChild(jspdf);

This is another solution: https://github.com/zeltox/Google-Drive-PDF-Downloader

And another, but very similar with the above two: