loading data from different database

[gautam mahendru]

Hello people.

I have a very unusual query. I work in a marketing dept. where i come across
preparing offers for my clients everyday. Data for the specific product
remain the same. So if i am choosing one product then my whole offer in word
document is changed accordingly.

I wish that if in word i can chose the product and all the technical and
commercial specification is listed automatically. I tried with WEB page but
it is giving me boxes which comes in print out. which i dont want.

Anyone please help me.

Thanks and regards.

gautam mahendru

 

[Phil Stokes]

I would suggest that you use mailmerge with data for each product being
stored as a file using the "Word Merge format (ie each field delimited by
both quote marks and comma such as "field","nextfield","etc"

you can then use a small form to choose which file to use to input into the
mail merge document.

ActiveDocument.MailMerge.OpenDataSource Name:= _
"YourProductX.txt", ConfirmConversions:=False, ReadOnly:= _
False, LinkToSource:=True, AddToRecentFiles:=False,
PasswordDocument:="", _
PasswordTemplate:="", WritePasswordDocument:="",
WritePasswordTemplate:= _
"", Revert:=False, Format:=wdOpenFormatAuto, Connection:="",
SQLStatement _
:="", SQLStatement1:=""
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=True
End With


If you have a database you could automate the production of these product
files so that they are always up to date.

Just a suggestion

Phil Stokes

 

[gautam mahendru]

Dear Phil,

Thanks. I appreciate your suggestion. It seems that i have to do programming
in VB. I am not so well versed with the syntax of it. But i will learn.

Advice me if similar type of things are available so that i can get a jump
start.

Regards

Gautam Mahendru