Hello everyone
I have a VBA code for sending an Excel sheet as a PDF.
To the file I add text.
I have a problem with the text because I need it to be on the right (Hebrew language).
After an extensive search on the Internet I did not find a solution.
I would appreciate your help,
Kobi
That's part of the code:
SendTo = ActiveSheet.Cells(3, 3)
If FileName <> "" Then
RDB_Mail_PDF_Outlook FileNamePDF:=FileName, _
StrTo:=ActiveSheet.Cells(47, 3), _
StrCC:="", _
StrBCC:="", _
StrSubject:="שכר עידוד", _
Signature:=True, _
Send:=False, _
StrBody:="<H3><B>...לכבוד</B></H3><br>" & SendTo & _
"<body>מצורף דוח שכר עידוד לעיונך" & _
"<br><br>" & "בברכה תחום שכר עידוד</body>"