• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

birthday reminder - body text to the right.

rico melas

New Member
birthday reminder - how do I put mail body text to the right?
I have used your template whith the Hiperlink code and would like to add an other code in order to align the text body to the right.
Thank you
Rico
 

rico melas

New Member
Thank you for your quick reply,
As a new user i did visit and read the forum terms...
i add my file but i it in Hebrew - i hope you will be abble o help me.
Tnks in advance
Rico
 

SirJB7

Excel Rōnin
Hi, rico melas!

Your uploaded file is a .xlsx type so it hasn't any macros, hence I couldn't check your actual code to analyze your problem. Please upload a .xlsm file or at least post the code here using the 5th icon from the right of the toolbar.

About Hebrew which I don't understand at all I hope that it won't interfere in the code analysis; if not you'll be the 2nd in finding out.

Regards!
 

rico melas

New Member
Hi, rico melas!

Your uploaded file is a .xlsx type so it hasn't any macros, hence I couldn't check your actual code to analyze your problem. Please upload a .xlsm file or at least post the code here using the 5th icon from the right of the toolbar.

About Hebrew which I don't understand at all I hope that it won't interfere in the code analysis; if not you'll be the 2nd in finding out.

Regards!
I thought I could add another command to heperlink That's why I did not try to use the macro.
Please find att. a .xlsm file
Tnks
Rico
 

Attachments

SirJB7

Excel Rōnin
Hi, rico melas!

Your file now is a .xlsm but it still has no macros at all. Let me see if I understood correctly your issue:
how do I put mail body text to the right?
I have used your template whith the Hiperlink code and would like to add an other code in order to align the text body to the right.
I believed that you:
- have created hyperlinks for the addresses
- had certain code for sending mails
- the body of the mail was Western-aligned (left) and you wanted it Middle-Easern-aligned (right)

Correct me if I'm wrong.

Regards!

PS: Had been only for the file type I wouldn't have asked you to upload again the file, it was the code that I wanted to check to see what could be done to solve your issue.
 

rico melas

New Member
Hi, rico melas!

Your file now is a .xlsm but it still has no macros at all. Let me see if I understood correctly your issue:


I believed that you:
- have created hyperlinks for the addresses
- had certain code for sending mails
- the body of the mail was Western-aligned (left) and you wanted it Middle-Easern-aligned (right)

Correct me if I'm wrong.

Regards!

PS: Had been only for the file type I wouldn't have asked you to upload again the file, it was the code that I wanted to check to see what could be done to solve your issue.
you are correct very much
thank you
Rico
 

SirJB7

Excel Rōnin
Hi, rico melas!
Then, where's the code that you yet have? If you don't post it or upload a file that contains it will be more difficult to obtain proper answers.
Regards!
 

rico melas

New Member
Hi, rico melas!
Then, where's the code that you yet have? If you don't post it or upload a file that contains it will be more difficult to obtain proper answers.
Regards!
I thought you understood that I did not create the macro code.
I used your template file and I want to move the text to the right in the email.
I repeat - I do not have to write a macro code to the right.
I ask you to add a function or macro to pass the text to the right.
If this is not possible with you - I will understand.
Thanks
 

SirJB7

Excel Rōnin
Hi, rico melas!

Ok, I got it now, I apologize for misreading.

I've never faced issues regarding right-to-left languages except in this project:
http://chandoo.org/forum/threads/excel-multilanguage-formula-translator-and-function-reference.4789/
and I couldn't have the chance to test it or have it tested for me.

But about mailing from Excel, there're a lot of threads in this forums, and in most of them we usually lead user to this main link:
http://www.rondebruin.nl/win/section1.htm

Besides there're a lot of questions of this kind, here some of them:
http://chandoo.org/forum/threads/send-automated-email-due-date.13590/#post-80685
http://chandoo.org/forum/threads/need-help-organizing-excel-files-solved.10107/#post-57952
http://chandoo.org/forum/threads/row-merging-based-column-values.9936/#post-56814

If you don't happen to manage to handle it, please advise and surely someone will help you.

In any case I suggest you to leave the right alignment as the last task.

Regards!
 
Top