[mso] Re: Word Merge +Graphic Signature
- From: "Andrew Kendon" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 6 Sep 2005 22:42:35 +0100
You mean to say, Glenda, that the letters aren't all personally signed by
the managers?
Tush! And Pish tush!
However, it seemed to me that the passage you quoted contained the answer:
If your data document contains, in one field, a path to the appropriate
manager's *pseudo-signature* as a .gif or .jpg ... that is, fields for:
Name, Address ..., Manager, SigLocation, &c
Then the appropriate mergefield would be:
{INCLUDEPICTURE "{MERGEFIELD SigLocation}" \d}
and for each successive record you will get the appropriate signature ...
and your managers will not suffer from writer's cramp ;)
This is the way I read the article ... I hope it helps.
Andrew
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells
> Sent: 06 September 2005 20:20
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Word Merge +Graphic Signature
>
> Hi All.
> Please forgive me if this is a repeat. The demons of outer
> space absconded with all of my email Friday afternoon and it
> had to be restored by our IT. Of course recent stuff wasn't available.
>
> I had asked if there was a way to merge a specific graphic
> (signature) image into a word merge document.
>
> I found the below information on the web and it's great but
> I'd like to carry it one step further.
>
> Is there a way to do this and merge a specific graphic based
> on text within the document?
>
> Our objective is to have a signature image for each manager.
> We batch produce the letters which go out around the country
> based on territories, so even though the letter is the same,
> it's the responsibility of a territory manager. A letter to
> FL for example needs to be signed by Mrs. Smith while a
> letter to California would be Mr.
> Thomas.
>
> Thanks. /glenda
>
> The key to merging graphics is to make sure that you don't
> try to merge the graphic itself, but to merge a field that
> "points" to the graphic file. For instance, you might have an
> Excel worksheet that contains a group of real estate
> listings. Just make sure you set up your worksheet so that it
> contains the file address of the graphic you want to merge.
> Each record in the worksheet should have a complete drive
> name, path, and file name (in a single column) for the
> graphic associated with that record. The following is an
> example of such a file address:
> d:\listings\myhouses\smithhouse.jpg
> For the purposes of this discussion, let's assume that you
> named the column PictureLocation. When you create your merge
> document in Word, you can include a merge field such as this:
> {INCLUDEPICTURE "{MERGEFIELD PictureLocation}" \d} Notice
> that this is actually two fields within one. It is important
> to make sure that you include the quote marks, as indicated.
> When Word merges the document, it replaces the MERGEFIELD
> field with the data indicated. Thus, the example would become this:
> {INCLUDEPICTURE "d:\listings\myhouses\smithhouse.jpg" \d} The
> remaining INCLUDEPICTURE field is then translated by Word as
> a directive to include the noted picture.
> It is important to remember that after you perform your merge
> operation in Word, it may appear that your graphic merge
> didn't work properly. To speed things up, Word displays the
> same picture for each of the INCLUDEPICTURE fields. Thus,
> your merged document will appear as if it contains multiple
> instances of the same picture. This simply occurs because
> Word doesn't update the INCLUDEPICTURE field for each record
> it merges. To force this, simply select the entire document
> and press F9, or print the merged documents. (Word normally
> updates all fields prior to printing.)
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
