[mso] Re: Word Merge +Graphic Signature

Don't get me started Andrew on sending out letters w/pictures of
signatures. i hafta support it but.....

I can get one signature to merge but if a batch of letters is destined
for 5 different places than I need 5 different "signatures" and I don't
want to have to produce each letter according to which manager is
responsible. I'd have to run the merges more than 30 different times
several times a day.

I'm hoping there is a way to do the merge and based on something within
the document to have the correct signature image put on the document.
Like if the state is FL then INCLUDEPICTURE....Florida, if the states is
CO, then INCLUDEPICTURE....Colorado.

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Andrew Kendon
Sent: Tuesday, September 06, 2005 05:43 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word Merge +Graphic Signature

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

> -----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
>=20
> Hi All.
> Please forgive me if this is a repeat. The demons of outer space=20
> absconded with all of my email Friday afternoon and it had to be=20
> restored by our IT. Of course recent stuff wasn't available.
>=20
> I had asked if there was a way to merge a specific graphic
> (signature) image into a word merge document. =20
>=20
> I found the below information on the web and it's great but I'd like=20
> to carry it one step further.
>=20
> Is there a way to do this and merge a specific graphic based on text=20
> within the document?
>=20
> Our objective is to have a signature image for each manager. =20
> We batch produce the letters which go out around the country based on=20
> territories, so even though the letter is the same, it's the=20
> responsibility of a territory manager.  A letter to FL for example=20
> needs to be signed by Mrs. Smith while a letter to California would be

> Mr.
> Thomas.
>=20
> Thanks. /glenda
>=20
> The key to merging graphics is to make sure that you don't try to=20
> merge the graphic itself, but to merge a field that "points" to the=20
> graphic file. For instance, you might have an Excel worksheet that=20
> contains a group of real estate listings. Just make sure you set up=20
> 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,=20
> and file name (in a single column) for the graphic associated with=20
> 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=20
> column PictureLocation. When you create your merge document in Word,=20
> 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=20
> include the quote marks, as indicated.
> When Word merges the document, it replaces the MERGEFIELD field with=20
> the data indicated. Thus, the example would become this:
> {INCLUDEPICTURE "d:\listings\myhouses\smithhouse.jpg" \d} The=20
> remaining INCLUDEPICTURE field is then translated by Word as a=20
> directive to include the noted picture.
> It is important to remember that after you perform your merge=20
> operation in Word, it may appear that your graphic merge didn't work=20
> properly. To speed things up, Word displays the same picture for each=20
> of the INCLUDEPICTURE fields. Thus, your merged document will appear=20
> as if it contains multiple instances of the same picture. This simply=20
> occurs because Word doesn't update the INCLUDEPICTURE field for each=20
> record it merges. To force this, simply select the entire document and

> press F9, or print the merged documents. (Word normally updates all=20
> fields prior to printing.)


        =09
___________________________________________________________
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).
http://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
*************************************************************
*************************************************************
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).
http://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: