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 / February 2004

Tip: Looking for answers? Try searching our database.

Merge Excel-file AND pictures (please help)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C.C. - 07 Feb 2004 00:55 GMT
Hello All,

Software is Office 2000.

I have an Excel-file with data. Merging this in a Word-file is no
problem of course, but what I want to do is also add/merge pictures
(jpg) I have in a special directory. I know this can be done one at a
time ;-), but I'm talking about 20.000 pictures, hence 20.000 pages.
I'll give an example below the sig, but first my questions.

Is it possible?
If so, how?
  Should I name the picture-files in a special way?
  Should I include the pictures in the Excel-file?
  Can it be done in one 'run'?
All ideas are welcome.

Thanks for your attention.

Best,
C.C.
---------
For email:
put an extra 'e' in the mailaddress. 'kes' should read 'kees'

=================================================================
Example. (I do hope my English is clear enough).

It's all about special routes for bikers and the signs we want to place
(and maintain). We need a seperate page with specifications for every
location where a sign has to be placed. The information on these pages
is about the material to use, the geographic location and the exact spot
(that's where the pictures come in). To keep it simple, let's say the
(fields in the) Excel-file look like this:
-gps1 (longitude)
-gps2 (latitude)
-region
-street
-position1 (sort of longitude in relation to the road)
-position2 (sort of latitude in relation to the road)
-material1
-material2
-material3
 etc
All text and numbers.

In a special directory I have pictures of each location and every page
should have such a picture.
Graham Mayor - 08 Feb 2004 10:32 GMT
The principles are explained at
http://www.gmayor.com/mail_merge_graphics.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hello All,
>
[quoted text clipped - 44 lines]
> In a special directory I have pictures of each location and every page
> should have such a picture.
 
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.