Solved

Formatting data in an email

Posted on 2003-12-03
15
152 Views
Last Modified: 2008-03-06
Using Microsoft Works data base I can print nicely formatted data in columns, using the "report" function.  How do I also get this report layout into an email without, as at present, losing the columnar formatting.

Every time I try I get e.g three columns of data bunched together, rather than the data being in 3 neat columns, with each row entry exactly under the previous row entry.

dan
0
Comment
Question by:danM
  • 6
  • 4
  • 3
  • +1
15 Comments
 
LVL 44

Expert Comment

by:CrazyOne
ID: 9868085
Send it as an attachment rather than the body of the email. Email clients tend to reformat the body of the email. And the person you are sending it to may have their email client setup with different formatting than what you send it in.
0
 

Author Comment

by:danM
ID: 9869174
Sounds good - but how to do.  I can print a beautifully formatted report to paper, but how to create it as an email attachment.  What sort of attachment - text is no good as data all lumped together, line by line, and not in columns.

There does not seem to be a print-to-file function windows in XP.

Somehow I need a picture or image of what goes on to paper (report format), as an email attachment, but Works seems to have no means of creating this, (early version).


dan
0
 
LVL 5

Accepted Solution

by:
Goofytouy earned 75 total points
ID: 9869454
My suggestion:

Install a Generic text printer on XP
When printing the report, select that printer. At the printer options dialog, check "Print as file".
Send that file (you may open in a text processor and reformat it if you like).

GoofytoUy
0
 
LVL 31

Expert Comment

by:rid
ID: 9876483
Can't your program save the report as an .rtf file or something?
/RID
0
 

Author Comment

by:danM
ID: 9876584
My early version of "Works" prints beautifully formatted reports on to paper, but does not seem to have an option to save the formatted print file.  Obviously I can save the database file, but not as far as I can find, the actual print file.

Someone help me to install a "generic text printer" as described above, please.
(Windows XP - pro)


Dan.
0
 
LVL 31

Assisted Solution

by:rid
rid earned 75 total points
ID: 9876998
Printers > Add new > Local printer and no autodetect of PnP printer > Type should be "Generic - Text only". Don't bother printing a test page.

When printing report, choose the text printer and choose print to file. The output file may get a .prn extension. Rename to .txt and attach or open in a word processor and copy>paste into the e-mail message.
/RID
0
 
LVL 5

Expert Comment

by:Goofytouy
ID: 9877072

Rid, when sending output to file, you name it as you wish.. it does not add the .prn

DanM, as I told you, you may "reformat" it, even with word prior to sending it via mail.


GoofytoUy
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 5

Expert Comment

by:Goofytouy
ID: 9903292
So rid uses my idea, and takes my points... Good Answer Rid.

GoofytoUy
0
 
LVL 31

Expert Comment

by:rid
ID: 9903411
I'd like to point out that I didn't "take" the points; the author (perhaps erroneously) awarded them to me.

I'd also like to point out that I did NOT use your idea, I gave a suggestion as to how install a generic "Text-only" printer.

I think that the fundamental solution was to print to file and the suggestions abot that procedure should be considered the answer to the question. My comment, as you can see, only deals with the printer install.

I'll post a link to this Q in the CS area and suggest transfer of points or other suitable action by the mod's.
/RID
0
 
LVL 5

Expert Comment

by:Goofytouy
ID: 9903828

Yes rid, you're right. You dealed with his second question, not the one that originate this.
I do not think you do not deserve the points, what I think is that you deserve a "Assisted answer", and mine should be the accepted one...

I'm sorry of my bad expression, but i'm a spanish speaker, not an english one, so sometimes, i
use the spanish conformation of the sentence.


GoofytoUy
0
 
LVL 31

Expert Comment

by:rid
ID: 9904093
It's OK - I'm swedish, so one can expect some difficulties with english here. I posted a Q in CS area and hopfully someone will take a look at putting things straight for this thread. I agree completely with you.

cheers
/RID
0
 

Author Comment

by:danM
ID: 9904265
I agree with rid as to correct destination of the points - but maybe we are all taking this too seriously - surely it is a bit of fun for all participants.

It is a bit difficult to decide who to "point" after a subsidiary question is set and answered, which may be just as important to the questioner as the original question.


Dan
0
 
LVL 5

Expert Comment

by:Goofytouy
ID: 9904537

This is going to change into episthemology...
Which was first? The egg or the chicken?

Let's say this (and just in a bit of fun):
I answer your question.
After that you ask how to implement my answer
Rid answer your second question.

On a linear basis... Rid act as my assistant ;-)
But never mind. I'm not going to make a skycrapper of this.

GoofytoUy
0
 
LVL 5

Expert Comment

by:Goofytouy
ID: 9904543
Ups... while I was writing, Netminder split the points...
Err... Let's say i say nothing :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you want to move up through the ranks in your technology career, talent and hard work are the bare necessities. But they aren’t enough to make you stand out. Expanding your skills, actively promoting your accomplishments and using promotion st…
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now