Inserting text at certain point in doc

[stigh]

Hi again,

Have following problem:

When sending mail from my base, according to what mailsystem receiver got, the formatting is changed. Me=Exchange, receiver=Lotus Notes.

If I want the text to start 20 spaces from left to right, without clearing these spaces (and text in same area), how do I put text 20 spaces into document?

Example:

Name:

Address:

Phone:

+++

Name: "here should the insertion begin, at 20 spaces into doc"

Address: "here should the insertion begin, at 20 spaces into doc"

Phone: "here should the insertion begin, at 20 spaces into doc"

(hehe, didn't even work in this post...)

This is so whatever mailsystem being used, the text insertions of the fields always start at the same point, so the text and mail is proper formatted.

Thx,

/stigh

[This message has been edited by stigh (edited October 16, 2000).]

[Chuck]

quote:

---

Originally posted by stigh:

Hi again,

Have following problem:

When sending mail from my base, according to what mailsystem receiver got, the formatting is changed. Me=Exchange, receiver=Lotus Notes.

If I want the text to start 20 spaces from left to right, without clearing these spaces (and text in same area), how do I put text 20 spaces into document?

Example:

Name:

Address:

Phone:

+++

Name: "here should the insertion begin, at 20 spaces into doc"

Address: "here should the insertion begin, at 20 spaces into doc"

Phone: "here should the insertion begin, at 20 spaces into doc"

(hehe, didn't even work in this post...)

This is so whatever mailsystem being used, the text insertions of the fields always start at the same point, so the text and mail is proper formatted.

Thx,

/stigh

[This message has been edited by stigh (edited October 16, 2000).]

---

Perhaps I'm not understanding the problem correctly, but why don't you simply add the spaces into the calculation:

="Name:***************" & NameField

Where where I've put asterisks, you place spaces?

If you don't know how many characters the label is going to be (in the above, it was five, so I used fifteen spaces), you can use an equation like this:

= Left( Label & "********************", 20 ) & NameField

Chuck