Email Macro won't send

[bocaj315]

I have created the following Macro based off Ron de Bruin's templates here http://www.rondebruin.nl/win/s1/outlook/bmail5.htm
It was working fine until I added more code to the strbody, but now, the macro runs through, no errors come up, and nothing gets sent. Any help/ideas?

Please Login or Register  to view this content.

[bocaj315]

I have made some changes and figured out that this part of the body is causing the problems.

Please Login or Register  to view this content.

The email sends but is blank. When I don't include this part, it sends fine; however, I need it. Is there a syntax error or something in it?

[Mordred]

I'm not sure if this matters but why do you have spaces after A & F ie: "A " _ "F "?

[bocaj315]

I want the value of A&B to be on the same line

[bocaj315]

it doesn't make a difference if I delete the space

[bocaj315]

Strangely it works when take out most of the content and leave

Please Login or Register  to view this content.

Can anyone Help?

[john55]

try this...

Please Login or Register  to view this content.

[bocaj315]

It prompts the error "next without for"

Please Login or Register  to view this content.

at the end of the

[john55]

sorry

Please Login or Register  to view this content.

[bocaj315]

it still prompts the same error on the "next"

[john55]

hmmm..

Please Login or Register  to view this content.

[bocaj315]

That one didn't send any email. The format below will send everything up until the line I have highlighted. After that, it starts to send a blank email. If delete that line and the other section I have highlighted the email will send fine.

Please Login or Register  to view this content.

[john55]

I changed the word "send" to "kkk..." and it worked
see this condition

Please Login or Register  to view this content.

[bocaj315]

I changed it and the email sends, but the entire email is blank

[john55]

strange...
see the file attached, it works for me, if it does not work for you...I am sorry!

[RichTea88]

The information in column B doesn't conatin a '/' or a '\' does it?

Seems like a stupid question but when my workbook was creating an automatic e-mail and my information had a back or front slash it left the e-mail blank.

[bocaj315]

this works except it sends an email to each contact every row of information.

[bocaj315]

you have the for i=2 nested under for each cell.

[john55]

is this what you are after?

Please Login or Register  to view this content.

[bocaj315]

No, I just want one email for each row of information sent to the email address in column K

[bocaj315]

nvm I got it

[BigDawg15]

bocaj315,

Please post the final code so others following the thread may learn from it.

Thank you in advance,

BigDawg15

[bocaj315]

Please Login or Register  to view this content.

[BigDawg15]

Awesome,

Thank you!

BigDawg15