Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
signature bitmaps?
Hi, I want to perform a mailmerge that will include signatures in the form
of bitmaps (or similar) I'm stuck on how to import an image file into an excel spreadsheet to perform this mail merge function. is this even possible? Cheers, Dean |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
signature bitmaps?
"Dean Collins" wrote in message ... Hi, I want to perform a mailmerge that will include signatures in the form of bitmaps (or similar) I'm stuck on how to import an image file into an excel spreadsheet to perform this mail merge function. is this even possible? { INCLUDEPICTURE "C:\\SIGS\\{ MERGEFIELD SURNAME }.jpg" } This statement pulls in a picture from a directory called SIGS, and the picture name is based on the surname field in the merge data - so you do not need to import an image into excel, it is just a matter of saving signatures and naming them to match the merge data. I had problems when I tried bitmaps and found jpegs worked better. Thankfully if for some reason there is no picture found with the right name, the merge still works and does not stop with an error. Graham |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
signature bitmaps?
hi thanks, I'll try jpgs instead. I read that example on another site now I
think I know what went wrong. Cheers, Dean "GTS" wrote in message ... "Dean Collins" wrote in message ... Hi, I want to perform a mailmerge that will include signatures in the form of bitmaps (or similar) I'm stuck on how to import an image file into an excel spreadsheet to perform this mail merge function. is this even possible? { INCLUDEPICTURE "C:\\SIGS\\{ MERGEFIELD SURNAME }.jpg" } This statement pulls in a picture from a directory called SIGS, and the picture name is based on the surname field in the merge data - so you do not need to import an image into excel, it is just a matter of saving signatures and naming them to match the merge data. I had problems when I tried bitmaps and found jpegs worked better. Thankfully if for some reason there is no picture found with the right name, the merge still works and does not stop with an error. Graham |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a signature | Microsoft Word Help | |||
send as attachment does not include signature | Microsoft Word Help | |||
Logo and Signature on template don't display | Microsoft Word Help | |||
Insert ELECTRONIC Signature (NOT DIGITAL) in Word Document? | Microsoft Word Help | |||
change spacing in a signature | Page Layout |