Help needed with tweaking Ron de Bruin's mail code

**andy_iyeng** · 04-23-2012, 10:33 AM

Hi ,

I have adaped Ron de Bruin's mail code and am in the process of creating a mailer tool.

While i can now create an email and pass the message body, i am in need of help to finish the work.

What i have is a 100 rows of data with email id

I need to filter and pass each row which is associated with the email id in the body of the mail

Hi,

Please Note

Name Email
Andy [email protected]

and the next as
Hi,

Please Note

Name Email
Sandy [email protected]

so and so forth.

Any help is greatly appreciated! Thanks in advance

**jaslake** · 04-23-2012, 11:01 AM

Cross posted here
http://www.mrexcel.com/forum/showthread.php?t=630554

**andy_iyeng** · 04-23-2012, 12:15 PM

Hi,

Yes, it is so, i am trying to close this last bit as I need to implement it very urgently, and the final piece is evading me or I am just nt able to adapt it!

**jaslake** · 04-24-2012, 07:24 PM

Hi andy_iyeng

Yes, well, you need to disclose that...Rule #8

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed

Provide the Link...perhaps you'll get some hits.

**andy_iyeng** · 04-25-2012, 02:46 AM

Hi Jas,

Gotcha! thanks!

**darshankmandya** · 03-23-2016, 08:02 AM

Hi,

This is very good forum and helping a lot in doing automation….

I have a query

How can I insert particular data/text from excel cell in between the text which is already in the mail body.

Ex:

Col A Col B Col C
xyz 28 Name1
ABC 29 Name2
DEF 30 Name3

Email body :

In First email -> My name is “xyz” and my age is “28” and bla…bla………and send this to “contact1”.
In Second email -> My name is “ABC” and my age is “29” and bla…bla……… and send this to “contact2.

This has to loop for all rows get the data and display in outlook email.

So if I click once it has to generate all the emails for all the rows in excel.

I have attached the file//.

Can you please help me on this.