Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

Merging multiple images to a page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnB - 18 Aug 2005 20:16 GMT
Hi.

I have set up mail merge from Access to Word many times. Now I want to mail
merge images and have many (different) images on a page - a bit like labels.
In fact I've used a label Wizard in Access to produce a report containing
three rows of five images on a landscape page with the name of the image
below each one. Each image and name is a separate record in Access.

What I really want is to produce a two page mail merged document. The first
page is a letter with the usual type of merge fields inserted. The second
page would contain, say, five rows of three images with appropriate name
underneath.

By the way, I know how to merge images and I can concatenate the image and
name records in Access so that I can produce a letter to one address with
multiple associated images. The way this works at present is that images and
names appear one below the other, in a column. I just want to be able to
spread them out, like a labels layout.

Has anyone any idea how I could proceed?

Thanks, JohnB

Doug Robbins - 18 Aug 2005 21:04 GMT
Is the data (your so-called "usual type of merge fields") AND the filename
info for each image all in the one record?  That is, you have a field for
each image that goes with an individual record.

If that is the case, just set up your mail merge document with the first
page as you want it, and on page 2, insert a table with the desired number
of rows and columns and insert an image mergefield in each cell of that
table.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi.
>
[quoted text clipped - 22 lines]
>
> Thanks, JohnB
JohnB - 19 Aug 2005 10:50 GMT
Thanks Doug.

Perhaps I'd better expand. The data being merged is based on records in a
"one to many" relationship. These records are brought together in a query
that creates a number of records, each containing various fields from the
"one" side and concatenated records from the "many" side. So each record
presented to the merge would have AddressLine1, AddressLine2, Town, County,
PostCode ( the "one side") then a Name field (from the "many" side)
containing, say, three names each with carriage return and line feed
characters. This produces a merge page containing an Address at the top and
then a column of the three names, one under the other, in the body text. The
field containing the image path (ImagePathAndFile)is in the "many" side
records, along with the Name field.

I'm guessing that I will also need to concatenate the ImagePathAndFile
field, to maintain the same "one to many" relationship i.e. many images to
one address.

Does this help? Anyway, I will have a look into using a Table, but I'm not
too sure if it will work. How would the table handle three image paths
concatenated into one field? How would I separate them in the field? As I
say, the Name concatenate uses carriage return and line feed characters to
force the Names into a column in the merged document but surely that will not
work with a Table.

Thanks again for the help, JohnB

> Is the data (your so-called "usual type of merge fields") AND the filename
> info for each image all in the one record?  That is, you have a field for
[quoted text clipped - 31 lines]
> >
> > Thanks, JohnB
Doug Robbins - 19 Aug 2005 12:12 GMT
I had a suspicion that was what you were working with hence the
qualification on my response.

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Or, if you create a Catalog (on in Word XP and later, it's called Directory)
type mailmerge main document with the mergefields in the cells of a one row
table in the mailmerge main document with the keyfield in the first cell in
the row and then execute that merge to a new document and then run the
following macro, it will create separate tables with the records for each
key field in them.  With a bit of further development, you may be able to
get it to do what you want.

' Macro to create multiple items per condition in separate tables from a
directory type mailmerge

Dim source As Document, target As Document, scat As Range, tcat As Range
Dim data As Range, stab As Table, ttab As Table
Dim i As Long, j As Long, k As Long, n As Long
Set source = ActiveDocument
Set target = Documents.Add
Set stab = source.Tables(1)
k = stab.Columns.Count
Set ttab = target.Tables.Add(Range:=Selection.Range, numrows:=1,
numcolumns:=k - 1)
Set scat = stab.Cell(1, 1).Range
scat.End = scat.End - 1
ttab.Cell(1, 1).Range = scat
j = ttab.Rows.Count
For i = 1 To stab.Rows.Count
   Set tcat = ttab.Cell(j, 1).Range
   tcat.End = tcat.End - 1
   Set scat = stab.Cell(i, 1).Range
   scat.End = scat.End - 1
   If scat <> tcat Then
       ttab.Rows.Add
       j = ttab.Rows.Count
       ttab.Cell(j, 1).Range = scat
       ttab.Cell(j, 1).Range.Paragraphs(1).PageBreakBefore = True
       ttab.Rows.Add
       ttab.Cell(j + 1, 1).Range.Paragraphs(1).PageBreakBefore = False
       For n = 2 To k
           Set data = stab.Cell(i, n).Range
           data.End = data.End - 1
           ttab.Cell(ttab.Rows.Count, n - 1).Range = data
       Next n
   Else
       ttab.Rows.Add
       For n = 2 To k
           Set data = stab.Cell(i, n).Range
           data.End = data.End - 1
           ttab.Cell(ttab.Rows.Count, n - 1).Range = data
       Next n
   End If
Next i

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thanks Doug.
>
[quoted text clipped - 72 lines]
>> >
>> > Thanks, JohnB
JohnB - 19 Aug 2005 13:05 GMT
Thanks Doug.

Hmmm. Lots to take in there. I'll have to spend some time looking into this.
If it looks too daunting, perhaps I'll just rely on the mail merge to produce
the first pages, with merge fields and text and use the access report to
produce the second pages, containing the images.

Thanks again, JohnB

> I had a suspicion that was what you were working with hence the
> qualification on my response.
[quoted text clipped - 134 lines]
> >> >
> >> > Thanks, JohnB
Doug Robbins - 19 Aug 2005 18:16 GMT
Why not do it all in Access?  That's what I would do.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thanks Doug.
>
[quoted text clipped - 165 lines]
>> >> >
>> >> > Thanks, JohnB
JohnB - 20 Aug 2005 16:04 GMT
Hi Doug.

Do it all in Access? Could you expand on that?

I'm using Mail Merge from Access to produce letters, where the text needs to
be changed over time. It would be usefull to be able to include pictures in
the merge but having a separate Access report to produce the pictures would
be acceptable, if a little more awkward to collate.

Thanks, JohnB

> Why not do it all in Access?  That's what I would do.
>
[quoted text clipped - 167 lines]
> >> >> >
> >> >> > Thanks, JohnB
Doug Robbins - 20 Aug 2005 16:58 GMT
The whole thing can be done as a report in Access.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Doug.
>
[quoted text clipped - 207 lines]
>> >> >> >
>> >> >> > Thanks, JohnB
JohnB - 20 Aug 2005 18:01 GMT
Hi Doug. How would Users modify the text parts, without having to go into
"design"? JohnB

> The whole thing can be done as a report in Access.
>
[quoted text clipped - 209 lines]
> >> >> >> >
> >> >> >> > Thanks, JohnB
Doug Robbins - 20 Aug 2005 21:01 GMT
I guess it's a case of the lesser of two evils.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Doug. How would Users modify the text parts, without having to go into
> "design"? JohnB
[quoted text clipped - 243 lines]
>> >> >> >> >
>> >> >> >> > Thanks, JohnB
JohnB - 21 Aug 2005 12:51 GMT
Yes, I suppost so. Signing off now. Thanks for your time Doug

> I guess it's a case of the lesser of two evils.
>
[quoted text clipped - 239 lines]
> >> >> >> >> > be
> >> >> >> >> > able
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.