Conceptually I understand where you are going and I agree, it seems as though
it would do the trick. However, I am a pitiful amateur and really can't code
anything in VBA for my life. I've done some C++ and various web based
markups, but VBA is beyond my scope of knowledge. I suppose I could go out
and find a book, and I might. Perhaps someone could show me a sample code or
something? I'm sure I could figure out the loop stuff online but what about
sending everything to Word? I'm just in a little over my head. Thanks to
all.
> Word mailmerge is not very good at dealing with the "mutliple records per
> item" scenario you describe.
[quoted text clipped - 28 lines]
> > and
> > forums, this is by far the most difficult thing I've undertaken.
Peter Jamieson - 02 Jun 2005 16:50 GMT
Well, Doug Robbins gave a link to some relvant VBA code the other day - it's
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
The code referenced by that article is more to do with merging a /single/
record but it might help ease you into working with VBA and Automation.
Creating an Access report to do this might also be a better option.
However, I'd assumed from your message that you had probably used VBA to do
what you needed. If you've just used merge fields, then you might be able to
extend that despite what I said. In essence, you would:
a. use a catalog/directory merge
b. use a data source that consists of one row per picture - every row has
to have the same structure so you cannot have one row for the "global
information" then one row per picture. What that usually means is that you
need to use an Access query to join the data captured in your main form and
the subform, i.e. the data in the main form would appear in every record.
c. Assuming you want a block of information at the beginning, with fields
from the main form, then enclose that whole block in an IF field that says
{ IF { MERGEREC } = 1 "put all the stuff you want at the beginning here" ""
} then put everything you want per picture here
d. ensure that the backslashes in the image pathnames (let's say they are
in a field called imagepathname) are doubled up, then use
{ INCLUDEPICTURE "{ MERGEFIELD imagepathname }" }
to include the pictures.
Peter Jamieson
> Conceptually I understand where you are going and I agree, it seems as
> though
[quoted text clipped - 51 lines]
>> > and
>> > forums, this is by far the most difficult thing I've undertaken.