Avatar of b001
b001
Flag for Afghanistan asked on

vfp9 sp2 design a leaflet

Hi Experts

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

Thanks
FoxPro

Avatar of undefined
Last Comment
Pavel Celba

8/22/2022 - Mon
Pavel Celba

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?
Pavel Celba

b001

ASKER
Hi  pcelba
MS Word would be good. I do have some variable data.
Please explain how to do it.
Thanks
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Cyril Joudieh

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
ASKER CERTIFIED SOLUTION
Pavel Celba

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.