Solved

vfp9 sp2  design a leaflet

Posted on 2013-01-04
5
423 Views
Last Modified: 2013-01-05
Hi Experts

I would like to design and then print a leaflet from within vfp
is it possible?

Thanks
0
Comment
Question by:b001
  • 3
5 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 38743528
Yes, it is possible BUT are you sure VFP is the right tool to design leaflets?

If the leaflet contains data from tables or Excel sheets then I would rather use e.g. MS Word and mail merge.

If the leaflet does not contain variable data then any text publishing tool can do better work for you.

Could you please better specify what should be the output?
0
 
LVL 42

Expert Comment

by:pcelba
ID: 38743549
0
 

Author Comment

by:b001
ID: 38743552
Hi  pcelba
MS Word would be good. I do have some variable data.
Please explain how to do it.
Thanks
0
 
LVL 27

Expert Comment

by:CaptainCyril
ID: 38743573
If I were you I would use one of two methods:

1) Word automation and mail merges
    a) create document in word
    b) create query in vfp
    c) record a macro in word
    d) translate the marco to vfp code
    e) run the macro from vfp to automate the merge and printing

2) Web Browser / HTML
    a) create an html document
    b) either use webbrowser on vfp screen or generate an HTML and print via internet explorer
    c) use automation to replace merge text like <first> with alltrim(query.first)
    d) save the generate html and print it
0
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 38743581
Mail merge in Word allows you to include variable data into your document. It is used namely for letters when you have a list of addresses and some other variable parts of the letter etc. You may also include table data into the Word and print it several times.

Steps to generate Word document are described at many places, e.g.
http://office.microsoft.com/en-us/word-help/word-mail-merge-a-walk-through-the-process-HA001034920.aspx
http://office.microsoft.com/en-us/word-help/use-mail-merge-to-create-and-print-letters-and-other-documents-HA101857701.aspx
http://support.microsoft.com/kb/294683

If you want to handle Word mail merge from FoxPro via automation then you may look here:
http://support.microsoft.com/kb/181926
http://www.hentzenwerke.com/catalog/autofox.htm
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

820 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