Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Including images in merges
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Including images in merges
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/cindy...r/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/...ttachments.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 "Peter Oliver" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge fails with images and section breaks | Mailmerge | |||
Merging multiple images to a page | Mailmerge | |||
Large documents containing many images | Formatting Long Documents | |||
Unlinking large number of images with macro in Word 97 | Formatting Long Documents | |||
word / outlook mail should allow including images from web source. | Microsoft Word Help |