MS Word 2007 Automation

[cs2009]

Using Visual Basic 2008.

Below is a code snippet I use to automate Word:

strLetter.Append("John Smith")
strLetter.Append(Environment.NewLine)
strLetter.Append("1 Main Street")
strLetter.Append(Environment.NewLine)
strLetter.Append("Any Town")
strLetter.Append(Environment.NewLine)

oWord.Selection.TypeText(strLetter.Text.ToString())

I use the same formatting with the NewLine to produce a pdf file, and this works fine. When I produce the Word document each NewLine is treated was a paragraph and the results is too much space between lines. The Word output looks like this:

John Smith

1 Main Street

Anytown

instead of this

John Smith
1 Main Street
Anytown

Can someone help me?

 

[jebenson]

Try using vbCR instead of Environment.Newline.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[cs2009]

Thanks but I already tried vbCr and vbLf. Same result.

 

[mansii]

Not sure bout this, but you can give it a try:

strLetter.Append("John Smith" & Environment.NewLine)

Good luck.