In the code something is wrong. The message body is blank. I want the matter in the message body. Please check it and give me a solution.
Thanking you in anticipation.
Mukesh
In the code something is wrong. The message body is blank. I want the matter in the message body. Please check it and give me a solution.
Thanking you in anticipation.
Mukesh
Hi, Mukesh,
if you assign values to the Variables after you passed them to Outlook itīs not surprising that the body of the email is empty.
And you should think about not using a hard coded range like Z8:Z3000 when the used range in the sheet goes for Z6:Z226.Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 11-10-2013 at 02:45 AM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello Holger,
Ok! Now there is a matter in message body but only one problem is there.
There should be only one name of a person after the salutation 'Dear'
For example:
Dear Mukesh,
Dear Holger,
Dear Sally,
There should be only one email address in a 'to' field because I don't want to show other members whom I have sent the mail.
The email addresses starts from cell z8 so I select the range from it.
Thank you.
Mukesh
Hi,, Mukesh,
I strongly disagree as this problem has nothing to do with the problem of an empty body in a mail - this is by design you have in there. You insisted on creating an array and passing that on. If you do, you pass all the names at once (email addresses and names). If you want to pass them all independently what should be the advantage of using an array as to my knowledge you would need to use a loop for that?
Ciao,
Holger
Hi Holger,
Sorry, Due to poor knowledge of bva it's happening. So I'm taking a guidance/solutions from you. I'm learning new things day by day.
As per the thread title the problem is solved. So what is your advice to achieve my target to send the mails independently to each person?
Guide me please. Thank you.
Mukesh
Hi, Mukesh,
I think you had the result before the change towards the strings was requested. Maybe you should not only request changes but maybe also ask if that request makes sense in what the result should be like.Please Login or Register to view this content.
As a lot of the Msg is fix I think it to be a better idea to include those text paseages into the HTML-body as to work with a lot of statics and only have variables for text which change on request for the mails.
Ciao,
Holger
Hi Holger,
Excellent! Now it's working fine as per my requirement.
Sorry for trouble. Because of my mistake you have to work hard on it for a long time. Really, you are a magician of excel programming.
Thank you very much once again. Have a nice day.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks