?
Solved

vfp9 sp2  design a leaflet

Posted on 2013-01-04
5
Medium Priority
?
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
The Summer 2017 Scholarship Winners have been announced!
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month10 days, 21 hours left to enroll

770 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