Solved

Formatting data in an email

Posted on 2003-12-03
15
153 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
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
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
 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

This is a quick article, and by no means should you quit your job today or plan to feed your family of 5 on a business idea. Starting a business takes work. This article will only give you the basic skeleton of understanding. Going into business for…
This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
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…
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.

822 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