Need Suggestions on How to do...

[Lhuffst]

I posted this under Microsoft but think I picked the wrong forum so I am reposting it here. [/color green]

I have a text document that prints labels from a mainframe on a continuous label. Need to reconfigure it to print on a laser printer and need suggestions as to the best method to accomplish this task.

On the mainframe, the file is run automatically and the users/computer operators want this to continue.

I can get the label on an avery 5161 but not sure which package to run this through which is why I'm asking for suggestions.

The text document from the mainframe looks like:

1
Joe Smoe Account Number
c/0 Joe Smoe 111111111
add 1 service address
city, state, zip 1111 woodhaven road

1
Account Number
sally smith 222222222
add 1 service address
city, state, zip 2222 woodhaven road

etc.


If I import it into access I have to use subreports so that the labels line up correctly AND would have to have a dedicated pc to use the program.

If I use word, then I can import it without problems but have to mess around with the top margin. I can get the top half of the label to print properly but about 1/2 down, the label on the right seems to shift up a bit which throws off the remaing right side labels.

Any suggestions would be appreciated.
Thanks
Lhuffst

 

[SkipVought]

Hi,

Move heaven and earth to get the data in TABULAR format, like...
[tt]
FullName CareOf Addr1 CSZ AcctNo SvcAddr
[/tt]
Then use MS Word, Mail Merge to LABLES.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

and short of that, I'd write some code to reformat the file into tabular format, form which it will be easy to generate lables as above.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Lhuffst]

thanks for the tip. I'll try that.