Writing Text file using Print Command

[Question Boy]

Hi I am using Albert's Super Easy MailMerge, well the txt file generation
routine. it use the following line

Print #intFile, strData

to populate a text file.

My strData can get rather large and appear to be having issues if it exceed
255 chrs. Is Print limited top 255 chrs? If so, what alternative method
could I use instead? If not, am I missing something else?

Also, I tried to google different subject to find info on the Print command,
but got all sort of irrelevant info on printing..., What is the proper term
to look this up?

Thank you

QB

 

[ryguy7272]

I'm not familiar with that Mail Merge method, but check this out this video
tutorial of how to simulate Mail Merge (and it shows how to do an actual Mail
Merge too):
http://datapigtechnologies.com/flashfiles/mailmerge.html

Regards,
Ryan---

 

[Question Boy]

Thank you for the link, I will take a look at it.

 

[dymondjack]

Lookup "VBA File IO" and you should see some subject matter on how to deal
with text files. I'm not sure how detailed you'll find info on the Print
command, most of what I've looked at in the past on the subject was pretty
stripped (I don't think there's much to it actually), and unfortunately I
don't know too much about the character limit.

hth

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill

 

[ryguy7272]

Please click 'Yes', if the post was helpful to you.

 

[Stuart McCall]

Hi I am using Albert's Super Easy MailMerge, well the txt file generation
routine. it use the following line

Print #intFile, strData

to populate a text file.

My strData can get rather large and appear to be having issues if it
exceed
255 chrs. Is Print limited top 255 chrs? If so, what alternative method
could I use instead? If not, am I missing something else?

Try this:

Open "MyFileName" For Binary Access Write As intFile
Put #intFile, , strData
Close intFile

That will write out the entire contents of strData. If you still get only
255 chars then something else is wrong.
Is strData being filled via a memo field?

Also, I tried to google different subject to find info on the Print
command,
but got all sort of irrelevant info on printing..., What is the proper
term
to look this up?

Try searching for "Print # Statement"

 

[Albert D. Kallal]

My strData can get rather large and appear to be having issues if it

exceed
255 chrs. Is Print limited top 255 chrs? If so, what alternative method
could I use instead? If not, am I missing something else?

There not a limit on the line size, but if your query has any type of
formatting function, then access often truncates the ONE field to 255.

so, there not a limit on the output, but if you using a query with some
function on a particular column, it can get truncated....

I would open up the query that the merge is based on, and double check if it
truncating at that point in time....