Mail Merge (Urgent Help Need)

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi everyone,

I want to build a command button to merge a query to a
word document. Could anyone tell me how to do it?

I have a query(ComInfo) like this:

ComName ProductID
X 1
y 2
L 3

And I have a word document (FormLetter.doc) like this:

<<comName>> is testing product<<ProductID>>.



I tried to build a report to display the data, but the
output was not what I expected. When the report was
exported to word document, all the logo image were gone.
I tried couple different way to export the report but had
the same output.

Any help will be appreciated.

Thanks,

Tim.
 
Albert,

Thanks for your help. I donwloaded the database
from "http://www.attcanada.net/~kallal.msn/msaccess/msacces
s.html". It works fine for one record, but it doesn't
work for all records(generate an error message). Is there
has a way to make it work?

I also took a look
on "http://homepage.swissonline.ch/cindymeister/MergFram.ht
m4", but the site was not exist. Could you check the link
again? I mean which database you are talking about.

I found some code
on "http://homepage.swissonline.ch/cindymeister" which
were very interesting, but I couldn't figure out how it
work? Could you help me to figure out how it works?

Explaination & Code:

Merge in a picture from a database
Word cannot merge a graphic or OLE-object directly from a
database because it does not understand the type of data
the database sends across (long binary). Therefore, you
have to workaround this obstacle.

Save the graphics files in a folder (directory) on a drive
Place the file name (or path information) in a field in
the database
Reference the graphic file information by nesting the
merge field in an IncludePicture field.
Example: { IncludePicture "C:\\Data\\Pics\\{ Mergefield
Signature \* upper }" }
You must now merge to a new document.
Update the field display so that each record shows the
correct picture. (You can press Ctrl+A to select the
entire document, then F9 to update the fields.)
Note the double backslashes in the example, as well as the
double-quotes. Both are necessary if the field is to work
correctly.

Thank you very much,

Tim.
 
Back
Top