insert variable string in email macro

what i'm trying to make, is a macro where in 1 click, i can send an email... the most part is the same.. but some parts can change..

so in this code i created, it should prompt for an input box where i can enter the name(LOB) so it will come into the email when it goes

Please Login or Register  to view this content.

the problem is.. when i try running this code.. the string entered in the "LOB" and "interval" inputbox would add the text on the same line as the other text...
it seems to neglect the effect of the VBnewline statement...
i wanted it to show like:

Request for VTO: **LOBname**
Intervals Stated Below: **2100 - 2300 EST**
Amount FTE : 10 (reductions) per interval


but it show like this:

Request for VTO: **LOBname** Intervals Stated Below: **2100 - 2300 EST** Amount FTE : 10 (reductions) per interval


any better ideas?

Hi, ag273n,

maybe try it like this:

Please Login or Register  to view this content.

Ciao,
Holger

worked perfectly! thanks!