Including images in merges

[Peter Oliver]

Here's the problem

I am trying to find a way to include merged images along with other fields
contained in an excel to a merged email or document file.

I have the images stored on my hard drive, I have the recipients and the
merge fields in an excel spreadsheet.
I would like to be able to link part numbers in the excel spreadheet to the
images of the parts on the hard drive.
I then plan to mail merge a catalogue style email (list of specific parts
with images) to a list of recipients

Here's the icing if it's possible
Futhermore I would ideally like the resulting email to be a "form" that had
an order quantity that recipients can enter for each part (even better I the
form can calculate the total)
I could then receive email back with the quantity required that I can upload
to the sales system

There are a variable number of items in each group of emails i.e. could be
25 items this week and 125 next week
Reasonably literate but not a programmer. If possible can someone email me
an example so that I can study it and convert to my own use

Any help would greatly greatly appreciated

Thanks

Peter
(e-mail address removed)

 

[Doug Robbins - Word MVP]

As far as getting the images into the mailmerge is concerned, see the
"Graphics from data base" item under the "Special merges" section of fellow
MVP Cindy Meister's website at:

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

You are going to run into problems trying to create a catalog type mailmerge
that also contains the name of each individual recipient.

I would suggest that the catalog mailmerge just consist of the list of part
numbers and their image. In the mailmerge main document, the mergefields
for these should be inserted into the cells of a one row table. You could
have an extra column in that table for the quantity. After executing that
merge to a new document, which will contain a table with a row of data for
each record in your data source, you should then insert a row at the top of
the table into the cells of which you insert headings such as the part
number, picture and quantity and in the cells in the quantity column, you
could insert formfields as used in a protected form, by use by the
recipients in entering the quantity that they want to order. You could use
a macro to insert those fields if you want. Then that document should be
protected for forms, and then you could email it as an attachment to your
recipients, by using the method in the article "Mail Merge to E-mail with
Attachments" at:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

--
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