[mso] Re: Word Merge +Graphic Signature
- From: "Dian D. Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 04:25:19 -0500
Not sure if this hits the mark, but you might want to check it out...
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=283
It may not appear to be what you want, but it MAY have some of the info you
need???
Good luck../.
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Glenda Wells
Sent: Tuesday, September 06, 2005 2:20 PM
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.)
*************************************************************
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
*************************************************************
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/90 - Release Date: 9/5/2005
--
This email scanned and certified clean by AVG!
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/91 - Release Date: 9/6/2005
*************************************************************
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:
