|
|
I'm currently working on a database of employees for my supervisor. I'm
making individual profiles of employees by using the mail-merge feature in
Microsoft word to take the data from the spreadsheet and filter it into word
documents. This part is going wonderfully... BUT, my supervisor told me today
that he wants ID pictures included with each profile. Is there a way for me
to insert a picture into a cell on the spreadsheet so that mail merge will
automatically sort the pictures to the correct files along with the rest of
the data? Any input would be greatly appreciated, thanks!
|
|
Put the the full pathname of the ID picture in a cell in Excel (you may also
have to double up any backslashes in the name, or use single forward
slashes, e.g.
c:\\my id pictures\\xyz.jpg
or
c:/my id pictures/xyz.jpg
Let's suppose you put the filenames in a column called IDPicture.
Then use the following nested field in Word:
{ INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
(both pairs of {} have to be the special field codes you can insert using
ctrl-F9)
Alternatively, if all the pictures are in the same folder, say c:\my id
pictures, thenyou can put just the file name "xyz.jpg" in the IDPicture
column and use
{ INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
(Make sure there are no spaces that shouldn't be there).
Then merge to a new document, ctrl-A to select it, and press F9 to update
the fields to see the different pictures.
Peter Jamieson
"Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
[Quoted Text] > I'm currently working on a database of employees for my supervisor. I'm
> making individual profiles of employees by using the mail-merge feature in
> Microsoft word to take the data from the spreadsheet and filter it into
> word
> documents. This part is going wonderfully... BUT, my supervisor told me
> today
> that he wants ID pictures included with each profile. Is there a way for
> me
> to insert a picture into a cell on the spreadsheet so that mail merge will
> automatically sort the pictures to the correct files along with the rest
> of
> the data? Any input would be greatly appreciated, thanks!
>
>
|
|
perhaps I'm not doing something right, but after I enter in
{ INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d } with
the modified file parameters, etc... the text just disappears and no image is
present.
"Peter Jamieson" wrote:
[Quoted Text] > Put the the full pathname of the ID picture in a cell in Excel (you may also
> have to double up any backslashes in the name, or use single forward
> slashes, e.g.
>
> c:\\my id pictures\\xyz.jpg
> or
> c:/my id pictures/xyz.jpg
>
> Let's suppose you put the filenames in a column called IDPicture.
>
> Then use the following nested field in Word:
>
> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>
> (both pairs of {} have to be the special field codes you can insert using
> ctrl-F9)
>
> Alternatively, if all the pictures are in the same folder, say c:\my id
> pictures, thenyou can put just the file name "xyz.jpg" in the IDPicture
> column and use
>
> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
>
> (Make sure there are no spaces that shouldn't be there).
>
> Then merge to a new document, ctrl-A to select it, and press F9 to update
> the fields to see the different pictures.
>
> Peter Jamieson
>
>
> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> > I'm currently working on a database of employees for my supervisor. I'm
> > making individual profiles of employees by using the mail-merge feature in
> > Microsoft word to take the data from the spreadsheet and filter it into
> > word
> > documents. This part is going wonderfully... BUT, my supervisor told me
> > today
> > that he wants ID pictures included with each profile. Is there a way for
> > me
> > to insert a picture into a cell on the spreadsheet so that mail merge will
> > automatically sort the pictures to the correct files along with the rest
> > of
> > the data? Any input would be greatly appreciated, thanks!
> >
> >
>
>
|
|
While previewing the mail merge main document, use Alt-F9 to view the field
codes, then select { MERGEFIELD IDPicture }, right-click and select the
Toggle field code option. You should now see the complete file path name.
Apart from the doubled-up backslashes, is it /exactly/ the same as the
actual full path name of one of your images? (No extra spaces at the
beginning or end or around the file name, for example)
Peter Jamieson
"Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
[Quoted Text] > perhaps I'm not doing something right, but after I enter in
> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d } with
> the modified file parameters, etc... the text just disappears and no image
> is
> present.
>
> "Peter Jamieson" wrote:
>
>> Put the the full pathname of the ID picture in a cell in Excel (you may
>> also
>> have to double up any backslashes in the name, or use single forward
>> slashes, e.g.
>>
>> c:\\my id pictures\\xyz.jpg
>> or
>> c:/my id pictures/xyz.jpg
>>
>> Let's suppose you put the filenames in a column called IDPicture.
>>
>> Then use the following nested field in Word:
>>
>> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>>
>> (both pairs of {} have to be the special field codes you can insert using
>> ctrl-F9)
>>
>> Alternatively, if all the pictures are in the same folder, say c:\my id
>> pictures, thenyou can put just the file name "xyz.jpg" in the IDPicture
>> column and use
>>
>> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
>>
>> (Make sure there are no spaces that shouldn't be there).
>>
>> Then merge to a new document, ctrl-A to select it, and press F9 to update
>> the fields to see the different pictures.
>>
>> Peter Jamieson
>>
>>
>> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
>> > I'm currently working on a database of employees for my supervisor. I'm
>> > making individual profiles of employees by using the mail-merge feature
>> > in
>> > Microsoft word to take the data from the spreadsheet and filter it into
>> > word
>> > documents. This part is going wonderfully... BUT, my supervisor told me
>> > today
>> > that he wants ID pictures included with each profile. Is there a way
>> > for
>> > me
>> > to insert a picture into a cell on the spreadsheet so that mail merge
>> > will
>> > automatically sort the pictures to the correct files along with the
>> > rest
>> > of
>> > the data? Any input would be greatly appreciated, thanks!
>> >
>> >
>>
>>
|
|
It now reads "{ INCLUDEPICTURE "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
\* MERGEFORMAT \d }" which is not what I initially entered.
"Peter Jamieson" wrote:
[Quoted Text] > While previewing the mail merge main document, use Alt-F9 to view the field
> codes, then select { MERGEFIELD IDPicture }, right-click and select the
> Toggle field code option. You should now see the complete file path name.
> Apart from the doubled-up backslashes, is it /exactly/ the same as the
> actual full path name of one of your images? (No extra spaces at the
> beginning or end or around the file name, for example)
>
> Peter Jamieson
> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
> > perhaps I'm not doing something right, but after I enter in
> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d } with
> > the modified file parameters, etc... the text just disappears and no image
> > is
> > present.
> >
> > "Peter Jamieson" wrote:
> >
> >> Put the the full pathname of the ID picture in a cell in Excel (you may
> >> also
> >> have to double up any backslashes in the name, or use single forward
> >> slashes, e.g.
> >>
> >> c:\\my id pictures\\xyz.jpg
> >> or
> >> c:/my id pictures/xyz.jpg
> >>
> >> Let's suppose you put the filenames in a column called IDPicture.
> >>
> >> Then use the following nested field in Word:
> >>
> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
> >>
> >> (both pairs of {} have to be the special field codes you can insert using
> >> ctrl-F9)
> >>
> >> Alternatively, if all the pictures are in the same folder, say c:\my id
> >> pictures, thenyou can put just the file name "xyz.jpg" in the IDPicture
> >> column and use
> >>
> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
> >>
> >> (Make sure there are no spaces that shouldn't be there).
> >>
> >> Then merge to a new document, ctrl-A to select it, and press F9 to update
> >> the fields to see the different pictures.
> >>
> >> Peter Jamieson
> >>
> >>
> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> >> > I'm currently working on a database of employees for my supervisor. I'm
> >> > making individual profiles of employees by using the mail-merge feature
> >> > in
> >> > Microsoft word to take the data from the spreadsheet and filter it into
> >> > word
> >> > documents. This part is going wonderfully... BUT, my supervisor told me
> >> > today
> >> > that he wants ID pictures included with each profile. Is there a way
> >> > for
> >> > me
> >> > to insert a picture into a cell on the spreadsheet so that mail merge
> >> > will
> >> > automatically sort the pictures to the correct files along with the
> >> > rest
> >> > of
> >> > the data? Any input would be greatly appreciated, thanks!
> >> >
> >> >
> >>
> >>
>
>
|
|
OK,
1. you also need to uncheck Word Tools|Options|General|Web
options|Files|"Update links on save" and try again.(Even though what you are
doing has nothing to do with the Web)
2. You need to ensure that the { MERGEFIELD IDPciture } is a /field/ - use
ctrl-F9 to insert the special field code braces - typing them from the
keyboard doesn't work.
Peter Jamieson
"Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
[Quoted Text] > It now reads "{ INCLUDEPICTURE
> "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
> \* MERGEFORMAT \d }" which is not what I initially entered.
>
> "Peter Jamieson" wrote:
>
>> While previewing the mail merge main document, use Alt-F9 to view the
>> field
>> codes, then select { MERGEFIELD IDPicture }, right-click and select the
>> Toggle field code option. You should now see the complete file path name.
>> Apart from the doubled-up backslashes, is it /exactly/ the same as the
>> actual full path name of one of your images? (No extra spaces at the
>> beginning or end or around the file name, for example)
>>
>> Peter Jamieson
>> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
>> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
>> > perhaps I'm not doing something right, but after I enter in
>> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
>> > with
>> > the modified file parameters, etc... the text just disappears and no
>> > image
>> > is
>> > present.
>> >
>> > "Peter Jamieson" wrote:
>> >
>> >> Put the the full pathname of the ID picture in a cell in Excel (you
>> >> may
>> >> also
>> >> have to double up any backslashes in the name, or use single forward
>> >> slashes, e.g.
>> >>
>> >> c:\\my id pictures\\xyz.jpg
>> >> or
>> >> c:/my id pictures/xyz.jpg
>> >>
>> >> Let's suppose you put the filenames in a column called IDPicture.
>> >>
>> >> Then use the following nested field in Word:
>> >>
>> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>> >>
>> >> (both pairs of {} have to be the special field codes you can insert
>> >> using
>> >> ctrl-F9)
>> >>
>> >> Alternatively, if all the pictures are in the same folder, say c:\my
>> >> id
>> >> pictures, thenyou can put just the file name "xyz.jpg" in the
>> >> IDPicture
>> >> column and use
>> >>
>> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
>> >>
>> >> (Make sure there are no spaces that shouldn't be there).
>> >>
>> >> Then merge to a new document, ctrl-A to select it, and press F9 to
>> >> update
>> >> the fields to see the different pictures.
>> >>
>> >> Peter Jamieson
>> >>
>> >>
>> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
>> >> > I'm currently working on a database of employees for my supervisor.
>> >> > I'm
>> >> > making individual profiles of employees by using the mail-merge
>> >> > feature
>> >> > in
>> >> > Microsoft word to take the data from the spreadsheet and filter it
>> >> > into
>> >> > word
>> >> > documents. This part is going wonderfully... BUT, my supervisor told
>> >> > me
>> >> > today
>> >> > that he wants ID pictures included with each profile. Is there a way
>> >> > for
>> >> > me
>> >> > to insert a picture into a cell on the spreadsheet so that mail
>> >> > merge
>> >> > will
>> >> > automatically sort the pictures to the correct files along with the
>> >> > rest
>> >> > of
>> >> > the data? Any input would be greatly appreciated, thanks!
>> >> >
>> >> >
>> >>
>> >>
>>
>>
|
|
Alrighty, I did what you said for number 1, and now the text is actually
appearing where it should, my only issue now is that instead of the picture
appearing in the space, only the file name is appearing.
"Peter Jamieson" wrote:
[Quoted Text] > OK,
>
> 1. you also need to uncheck Word Tools|Options|General|Web
> options|Files|"Update links on save" and try again.(Even though what you are
> doing has nothing to do with the Web)
>
> 2. You need to ensure that the { MERGEFIELD IDPciture } is a /field/ - use
> ctrl-F9 to insert the special field code braces - typing them from the
> keyboard doesn't work.
>
>
> Peter Jamieson
> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
> > It now reads "{ INCLUDEPICTURE
> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
> > \* MERGEFORMAT \d }" which is not what I initially entered.
> >
> > "Peter Jamieson" wrote:
> >
> >> While previewing the mail merge main document, use Alt-F9 to view the
> >> field
> >> codes, then select { MERGEFIELD IDPicture }, right-click and select the
> >> Toggle field code option. You should now see the complete file path name.
> >> Apart from the doubled-up backslashes, is it /exactly/ the same as the
> >> actual full path name of one of your images? (No extra spaces at the
> >> beginning or end or around the file name, for example)
> >>
> >> Peter Jamieson
> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
> >> > perhaps I'm not doing something right, but after I enter in
> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
> >> > with
> >> > the modified file parameters, etc... the text just disappears and no
> >> > image
> >> > is
> >> > present.
> >> >
> >> > "Peter Jamieson" wrote:
> >> >
> >> >> Put the the full pathname of the ID picture in a cell in Excel (you
> >> >> may
> >> >> also
> >> >> have to double up any backslashes in the name, or use single forward
> >> >> slashes, e.g.
> >> >>
> >> >> c:\\my id pictures\\xyz.jpg
> >> >> or
> >> >> c:/my id pictures/xyz.jpg
> >> >>
> >> >> Let's suppose you put the filenames in a column called IDPicture.
> >> >>
> >> >> Then use the following nested field in Word:
> >> >>
> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
> >> >>
> >> >> (both pairs of {} have to be the special field codes you can insert
> >> >> using
> >> >> ctrl-F9)
> >> >>
> >> >> Alternatively, if all the pictures are in the same folder, say c:\my
> >> >> id
> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
> >> >> IDPicture
> >> >> column and use
> >> >>
> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
> >> >>
> >> >> (Make sure there are no spaces that shouldn't be there).
> >> >>
> >> >> Then merge to a new document, ctrl-A to select it, and press F9 to
> >> >> update
> >> >> the fields to see the different pictures.
> >> >>
> >> >> Peter Jamieson
> >> >>
> >> >>
> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> >> >> > I'm currently working on a database of employees for my supervisor.
> >> >> > I'm
> >> >> > making individual profiles of employees by using the mail-merge
> >> >> > feature
> >> >> > in
> >> >> > Microsoft word to take the data from the spreadsheet and filter it
> >> >> > into
> >> >> > word
> >> >> > documents. This part is going wonderfully... BUT, my supervisor told
> >> >> > me
> >> >> > today
> >> >> > that he wants ID pictures included with each profile. Is there a way
> >> >> > for
> >> >> > me
> >> >> > to insert a picture into a cell on the spreadsheet so that mail
> >> >> > merge
> >> >> > will
> >> >> > automatically sort the pictures to the correct files along with the
> >> >> > rest
> >> >> > of
> >> >> > the data? Any input would be greatly appreciated, thanks!
> >> >> >
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>
|
|
OK, so when you Alt-F9 to display the "field results" you see something like
c:\\my id pictures\\mypicture.jpg
Or what?
You are welcome to despam my e-mail address (remove "KillmapS") and send me
copies of your document !
Peter Jamieson
"Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
[Quoted Text] > Alrighty, I did what you said for number 1, and now the text is actually
> appearing where it should, my only issue now is that instead of the
> picture
> appearing in the space, only the file name is appearing.
>
> "Peter Jamieson" wrote:
>
>> OK,
>>
>> 1. you also need to uncheck Word Tools|Options|General|Web
>> options|Files|"Update links on save" and try again.(Even though what you
>> are
>> doing has nothing to do with the Web)
>>
>> 2. You need to ensure that the { MERGEFIELD IDPciture } is a /field/ -
>> use
>> ctrl-F9 to insert the special field code braces - typing them from the
>> keyboard doesn't work.
>>
>>
>> Peter Jamieson
>> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
>> > It now reads "{ INCLUDEPICTURE
>> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
>> > \* MERGEFORMAT \d }" which is not what I initially entered.
>> >
>> > "Peter Jamieson" wrote:
>> >
>> >> While previewing the mail merge main document, use Alt-F9 to view the
>> >> field
>> >> codes, then select { MERGEFIELD IDPicture }, right-click and select
>> >> the
>> >> Toggle field code option. You should now see the complete file path
>> >> name.
>> >> Apart from the doubled-up backslashes, is it /exactly/ the same as the
>> >> actual full path name of one of your images? (No extra spaces at the
>> >> beginning or end or around the file name, for example)
>> >>
>> >> Peter Jamieson
>> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
>> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
>> >> > perhaps I'm not doing something right, but after I enter in
>> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
>> >> > with
>> >> > the modified file parameters, etc... the text just disappears and no
>> >> > image
>> >> > is
>> >> > present.
>> >> >
>> >> > "Peter Jamieson" wrote:
>> >> >
>> >> >> Put the the full pathname of the ID picture in a cell in Excel (you
>> >> >> may
>> >> >> also
>> >> >> have to double up any backslashes in the name, or use single
>> >> >> forward
>> >> >> slashes, e.g.
>> >> >>
>> >> >> c:\\my id pictures\\xyz.jpg
>> >> >> or
>> >> >> c:/my id pictures/xyz.jpg
>> >> >>
>> >> >> Let's suppose you put the filenames in a column called IDPicture.
>> >> >>
>> >> >> Then use the following nested field in Word:
>> >> >>
>> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>> >> >>
>> >> >> (both pairs of {} have to be the special field codes you can insert
>> >> >> using
>> >> >> ctrl-F9)
>> >> >>
>> >> >> Alternatively, if all the pictures are in the same folder, say
>> >> >> c:\my
>> >> >> id
>> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
>> >> >> IDPicture
>> >> >> column and use
>> >> >>
>> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
>> >> >> \d }
>> >> >>
>> >> >> (Make sure there are no spaces that shouldn't be there).
>> >> >>
>> >> >> Then merge to a new document, ctrl-A to select it, and press F9 to
>> >> >> update
>> >> >> the fields to see the different pictures.
>> >> >>
>> >> >> Peter Jamieson
>> >> >>
>> >> >>
>> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
>> >> >> > I'm currently working on a database of employees for my
>> >> >> > supervisor.
>> >> >> > I'm
>> >> >> > making individual profiles of employees by using the mail-merge
>> >> >> > feature
>> >> >> > in
>> >> >> > Microsoft word to take the data from the spreadsheet and filter
>> >> >> > it
>> >> >> > into
>> >> >> > word
>> >> >> > documents. This part is going wonderfully... BUT, my supervisor
>> >> >> > told
>> >> >> > me
>> >> >> > today
>> >> >> > that he wants ID pictures included with each profile. Is there a
>> >> >> > way
>> >> >> > for
>> >> >> > me
>> >> >> > to insert a picture into a cell on the spreadsheet so that mail
>> >> >> > merge
>> >> >> > will
>> >> >> > automatically sort the pictures to the correct files along with
>> >> >> > the
>> >> >> > rest
>> >> >> > of
>> >> >> > the data? Any input would be greatly appreciated, thanks!
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
|
the word document has this in the space: { MERGEFIELD IDPicture}
And in the corresponding excel cell: 265332.jpg
"Peter Jamieson" wrote:
[Quoted Text] > OK, so when you Alt-F9 to display the "field results" you see something like
>
> c:\\my id pictures\\mypicture.jpg
>
> Or what?
>
> You are welcome to despam my e-mail address (remove "KillmapS") and send me
> copies of your document !
>
> Peter Jamieson
>
>
> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
> > Alrighty, I did what you said for number 1, and now the text is actually
> > appearing where it should, my only issue now is that instead of the
> > picture
> > appearing in the space, only the file name is appearing.
> >
> > "Peter Jamieson" wrote:
> >
> >> OK,
> >>
> >> 1. you also need to uncheck Word Tools|Options|General|Web
> >> options|Files|"Update links on save" and try again.(Even though what you
> >> are
> >> doing has nothing to do with the Web)
> >>
> >> 2. You need to ensure that the { MERGEFIELD IDPciture } is a /field/ -
> >> use
> >> ctrl-F9 to insert the special field code braces - typing them from the
> >> keyboard doesn't work.
> >>
> >>
> >> Peter Jamieson
> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
> >> > It now reads "{ INCLUDEPICTURE
> >> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
> >> > \* MERGEFORMAT \d }" which is not what I initially entered.
> >> >
> >> > "Peter Jamieson" wrote:
> >> >
> >> >> While previewing the mail merge main document, use Alt-F9 to view the
> >> >> field
> >> >> codes, then select { MERGEFIELD IDPicture }, right-click and select
> >> >> the
> >> >> Toggle field code option. You should now see the complete file path
> >> >> name.
> >> >> Apart from the doubled-up backslashes, is it /exactly/ the same as the
> >> >> actual full path name of one of your images? (No extra spaces at the
> >> >> beginning or end or around the file name, for example)
> >> >>
> >> >> Peter Jamieson
> >> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in message
> >> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
> >> >> > perhaps I'm not doing something right, but after I enter in
> >> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }" \d }
> >> >> > with
> >> >> > the modified file parameters, etc... the text just disappears and no
> >> >> > image
> >> >> > is
> >> >> > present.
> >> >> >
> >> >> > "Peter Jamieson" wrote:
> >> >> >
> >> >> >> Put the the full pathname of the ID picture in a cell in Excel (you
> >> >> >> may
> >> >> >> also
> >> >> >> have to double up any backslashes in the name, or use single
> >> >> >> forward
> >> >> >> slashes, e.g.
> >> >> >>
> >> >> >> c:\\my id pictures\\xyz.jpg
> >> >> >> or
> >> >> >> c:/my id pictures/xyz.jpg
> >> >> >>
> >> >> >> Let's suppose you put the filenames in a column called IDPicture.
> >> >> >>
> >> >> >> Then use the following nested field in Word:
> >> >> >>
> >> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
> >> >> >>
> >> >> >> (both pairs of {} have to be the special field codes you can insert
> >> >> >> using
> >> >> >> ctrl-F9)
> >> >> >>
> >> >> >> Alternatively, if all the pictures are in the same folder, say
> >> >> >> c:\my
> >> >> >> id
> >> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
> >> >> >> IDPicture
> >> >> >> column and use
> >> >> >>
> >> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
> >> >> >> \d }
> >> >> >>
> >> >> >> (Make sure there are no spaces that shouldn't be there).
> >> >> >>
> >> >> >> Then merge to a new document, ctrl-A to select it, and press F9 to
> >> >> >> update
> >> >> >> the fields to see the different pictures.
> >> >> >>
> >> >> >> Peter Jamieson
> >> >> >>
> >> >> >>
> >> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> >> >> >> > I'm currently working on a database of employees for my
> >> >> >> > supervisor.
> >> >> >> > I'm
> >> >> >> > making individual profiles of employees by using the mail-merge
> >> >> >> > feature
> >> >> >> > in
> >> >> >> > Microsoft word to take the data from the spreadsheet and filter
> >> >> >> > it
> >> >> >> > into
> >> >> >> > word
> >> >> >> > documents. This part is going wonderfully... BUT, my supervisor
> >> >> >> > told
> >> >> >> > me
> >> >> >> > today
> >> >> >> > that he wants ID pictures included with each profile. Is there a
> >> >> >> > way
> >> >> >> > for
> >> >> >> > me
> >> >> >> > to insert a picture into a cell on the spreadsheet so that mail
> >> >> >> > merge
> >> >> >> > will
> >> >> >> > automatically sort the pictures to the correct files along with
> >> >> >> > the
> >> >> >> > rest
> >> >> >> > of
> >> >> >> > the data? Any input would be greatly appreciated, thanks!
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>
|
|
From what you say, I can only make guesses. I think you have not constructed
the fields the way that they need to be. Let's start with three ideas:
1. this works for lots of people but...
2. it is not yet working for you so...
3. the problem is likely to be something really simple
Let's try to go step-by-step...
<<
[Quoted Text] > the word document has this in the space: { MERGEFIELD IDPicture}
>>
Let's start with your field:
a. in Word, you see { MERGEFIELD IDPicture }
b. what do you see if you press Alt-F9? Do you see: "265332.jpg" ? (But
without the double-quote marks?)
Which folder contains the file
265332.jpg
?
Peter Jamieson
"Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
news:CEB6138D-39C6-43F7-A886-4CEF02D29FD5[ at ]microsoft.com...
> the word document has this in the space: { MERGEFIELD IDPicture}
> And in the corresponding excel cell: 265332.jpg
>
>
>
> "Peter Jamieson" wrote:
>
>> OK, so when you Alt-F9 to display the "field results" you see something
>> like
>>
>> c:\\my id pictures\\mypicture.jpg
>>
>> Or what?
>>
>> You are welcome to despam my e-mail address (remove "KillmapS") and send
>> me
>> copies of your document !
>>
>> Peter Jamieson
>>
>>
>> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
>> > Alrighty, I did what you said for number 1, and now the text is
>> > actually
>> > appearing where it should, my only issue now is that instead of the
>> > picture
>> > appearing in the space, only the file name is appearing.
>> >
>> > "Peter Jamieson" wrote:
>> >
>> >> OK,
>> >>
>> >> 1. you also need to uncheck Word Tools|Options|General|Web
>> >> options|Files|"Update links on save" and try again.(Even though what
>> >> you
>> >> are
>> >> doing has nothing to do with the Web)
>> >>
>> >> 2. You need to ensure that the { MERGEFIELD IDPciture } is a
>> >> /field/ -
>> >> use
>> >> ctrl-F9 to insert the special field code braces - typing them from the
>> >> keyboard doesn't work.
>> >>
>> >>
>> >> Peter Jamieson
>> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> >> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
>> >> > It now reads "{ INCLUDEPICTURE
>> >> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
>> >> > \* MERGEFORMAT \d }" which is not what I initially entered.
>> >> >
>> >> > "Peter Jamieson" wrote:
>> >> >
>> >> >> While previewing the mail merge main document, use Alt-F9 to view
>> >> >> the
>> >> >> field
>> >> >> codes, then select { MERGEFIELD IDPicture }, right-click and select
>> >> >> the
>> >> >> Toggle field code option. You should now see the complete file path
>> >> >> name.
>> >> >> Apart from the doubled-up backslashes, is it /exactly/ the same as
>> >> >> the
>> >> >> actual full path name of one of your images? (No extra spaces at
>> >> >> the
>> >> >> beginning or end or around the file name, for example)
>> >> >>
>> >> >> Peter Jamieson
>> >> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
>> >> >> > perhaps I'm not doing something right, but after I enter in
>> >> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
>> >> >> > \d }
>> >> >> > with
>> >> >> > the modified file parameters, etc... the text just disappears and
>> >> >> > no
>> >> >> > image
>> >> >> > is
>> >> >> > present.
>> >> >> >
>> >> >> > "Peter Jamieson" wrote:
>> >> >> >
>> >> >> >> Put the the full pathname of the ID picture in a cell in Excel
>> >> >> >> (you
>> >> >> >> may
>> >> >> >> also
>> >> >> >> have to double up any backslashes in the name, or use single
>> >> >> >> forward
>> >> >> >> slashes, e.g.
>> >> >> >>
>> >> >> >> c:\\my id pictures\\xyz.jpg
>> >> >> >> or
>> >> >> >> c:/my id pictures/xyz.jpg
>> >> >> >>
>> >> >> >> Let's suppose you put the filenames in a column called
>> >> >> >> IDPicture.
>> >> >> >>
>> >> >> >> Then use the following nested field in Word:
>> >> >> >>
>> >> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>> >> >> >>
>> >> >> >> (both pairs of {} have to be the special field codes you can
>> >> >> >> insert
>> >> >> >> using
>> >> >> >> ctrl-F9)
>> >> >> >>
>> >> >> >> Alternatively, if all the pictures are in the same folder, say
>> >> >> >> c:\my
>> >> >> >> id
>> >> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
>> >> >> >> IDPicture
>> >> >> >> column and use
>> >> >> >>
>> >> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
>> >> >> >> \d }
>> >> >> >>
>> >> >> >> (Make sure there are no spaces that shouldn't be there).
>> >> >> >>
>> >> >> >> Then merge to a new document, ctrl-A to select it, and press F9
>> >> >> >> to
>> >> >> >> update
>> >> >> >> the fields to see the different pictures.
>> >> >> >>
>> >> >> >> Peter Jamieson
>> >> >> >>
>> >> >> >>
>> >> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
>> >> >> >> > I'm currently working on a database of employees for my
>> >> >> >> > supervisor.
>> >> >> >> > I'm
>> >> >> >> > making individual profiles of employees by using the
>> >> >> >> > mail-merge
>> >> >> >> > feature
>> >> >> >> > in
>> >> >> >> > Microsoft word to take the data from the spreadsheet and
>> >> >> >> > filter
>> >> >> >> > it
>> >> >> >> > into
>> >> >> >> > word
>> >> >> >> > documents. This part is going wonderfully... BUT, my
>> >> >> >> > supervisor
>> >> >> >> > told
>> >> >> >> > me
>> >> >> >> > today
>> >> >> >> > that he wants ID pictures included with each profile. Is there
>> >> >> >> > a
>> >> >> >> > way
>> >> >> >> > for
>> >> >> >> > me
>> >> >> >> > to insert a picture into a cell on the spreadsheet so that
>> >> >> >> > mail
>> >> >> >> > merge
>> >> >> >> > will
>> >> >> >> > automatically sort the pictures to the correct files along
>> >> >> >> > with
>> >> >> >> > the
>> >> >> >> > rest
>> >> >> >> > of
>> >> >> >> > the data? Any input would be greatly appreciated, thanks!
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
|
when ALT-F9 is pressed, { MERGEFIELD IDPicture } appears, when ALT-F9 is
pressed again, 265332.jpg" (without the quotation marks) appears along with
the other desired information in other fields i.e. Name, Address, etc...
{ MERGEFIELD IDPicture } is set up as a field.
"Peter Jamieson" wrote:
[Quoted Text] > From what you say, I can only make guesses. I think you have not constructed
> the fields the way that they need to be. Let's start with three ideas:
> 1. this works for lots of people but...
> 2. it is not yet working for you so...
> 3. the problem is likely to be something really simple
>
> Let's try to go step-by-step...
>
> <<
> > the word document has this in the space: { MERGEFIELD IDPicture}
> >>
>
> Let's start with your field:
> a. in Word, you see { MERGEFIELD IDPicture }
> b. what do you see if you press Alt-F9? Do you see: "265332.jpg" ? (But
> without the double-quote marks?)
>
> Which folder contains the file
>
> 265332.jpg
>
> ?
>
> Peter Jamieson
>
> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> news:CEB6138D-39C6-43F7-A886-4CEF02D29FD5[ at ]microsoft.com...
> > the word document has this in the space: { MERGEFIELD IDPicture}
> > And in the corresponding excel cell: 265332.jpg
> >
> >
> >
> > "Peter Jamieson" wrote:
> >
> >> OK, so when you Alt-F9 to display the "field results" you see something
> >> like
> >>
> >> c:\\my id pictures\\mypicture.jpg
> >>
> >> Or what?
> >>
> >> You are welcome to despam my e-mail address (remove "KillmapS") and send
> >> me
> >> copies of your document !
> >>
> >> Peter Jamieson
> >>
> >>
> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
> >> > Alrighty, I did what you said for number 1, and now the text is
> >> > actually
> >> > appearing where it should, my only issue now is that instead of the
> >> > picture
> >> > appearing in the space, only the file name is appearing.
> >> >
> >> > "Peter Jamieson" wrote:
> >> >
> >> >> OK,
> >> >>
> >> >> 1. you also need to uncheck Word Tools|Options|General|Web
> >> >> options|Files|"Update links on save" and try again.(Even though what
> >> >> you
> >> >> are
> >> >> doing has nothing to do with the Web)
> >> >>
> >> >> 2. You need to ensure that the { MERGEFIELD IDPciture } is a
> >> >> /field/ -
> >> >> use
> >> >> ctrl-F9 to insert the special field code braces - typing them from the
> >> >> keyboard doesn't work.
> >> >>
> >> >>
> >> >> Peter Jamieson
> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> >> >> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
> >> >> > It now reads "{ INCLUDEPICTURE
> >> >> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
> >> >> > \* MERGEFORMAT \d }" which is not what I initially entered.
> >> >> >
> >> >> > "Peter Jamieson" wrote:
> >> >> >
> >> >> >> While previewing the mail merge main document, use Alt-F9 to view
> >> >> >> the
> >> >> >> field
> >> >> >> codes, then select { MERGEFIELD IDPicture }, right-click and select
> >> >> >> the
> >> >> >> Toggle field code option. You should now see the complete file path
> >> >> >> name.
> >> >> >> Apart from the doubled-up backslashes, is it /exactly/ the same as
> >> >> >> the
> >> >> >> actual full path name of one of your images? (No extra spaces at
> >> >> >> the
> >> >> >> beginning or end or around the file name, for example)
> >> >> >>
> >> >> >> Peter Jamieson
> >> >> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
> >> >> >> > perhaps I'm not doing something right, but after I enter in
> >> >> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
> >> >> >> > \d }
> >> >> >> > with
> >> >> >> > the modified file parameters, etc... the text just disappears and
> >> >> >> > no
> >> >> >> > image
> >> >> >> > is
> >> >> >> > present.
> >> >> >> >
> >> >> >> > "Peter Jamieson" wrote:
> >> >> >> >
> >> >> >> >> Put the the full pathname of the ID picture in a cell in Excel
> >> >> >> >> (you
> >> >> >> >> may
> >> >> >> >> also
> >> >> >> >> have to double up any backslashes in the name, or use single
> >> >> >> >> forward
> >> >> >> >> slashes, e.g.
> >> >> >> >>
> >> >> >> >> c:\\my id pictures\\xyz.jpg
> >> >> >> >> or
> >> >> >> >> c:/my id pictures/xyz.jpg
> >> >> >> >>
> >> >> >> >> Let's suppose you put the filenames in a column called
> >> >> >> >> IDPicture.
> >> >> >> >>
> >> >> >> >> Then use the following nested field in Word:
> >> >> >> >>
> >> >> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
> >> >> >> >>
> >> >> >> >> (both pairs of {} have to be the special field codes you can
> >> >> >> >> insert
> >> >> >> >> using
> >> >> >> >> ctrl-F9)
> >> >> >> >>
> >> >> >> >> Alternatively, if all the pictures are in the same folder, say
> >> >> >> >> c:\my
> >> >> >> >> id
> >> >> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
> >> >> >> >> IDPicture
> >> >> >> >> column and use
> >> >> >> >>
> >> >> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
> >> >> >> >> \d }
> >> >> >> >>
> >> >> >> >> (Make sure there are no spaces that shouldn't be there).
> >> >> >> >>
> >> >> >> >> Then merge to a new document, ctrl-A to select it, and press F9
> >> >> >> >> to
> >> >> >> >> update
> >> >> >> >> the fields to see the different pictures.
> >> >> >> >>
> >> >> >> >> Peter Jamieson
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> >> >> >> >> > I'm currently working on a database of employees for my
> >> >> >> >> > supervisor.
> >> >> >> >> > I'm
> >> >> >> >> > making individual profiles of employees by using the
> >> >> >> >> > mail-merge
> >> >> >> >> > feature
> >> >> >> >> > in
> >> >> >> >> > Microsoft word to take the data from the spreadsheet and
> >> >> >> >> > filter
> >> >> >> >> > it
> >> >> >> >> > into
> >> >> >> >> > word
> >> >> >> >> > documents. This part is going wonderfully... BUT, my
> >> >> >> >> > supervisor
> >> >> >> >> > told
> >> >> >> >> > me
> >> >> >> >> > today
> >> >> >> >> > that he wants ID pictures included with each profile. Is there
> >> >> >> >> > a
> >> >> >> >> > way
> >> >> >> >> > for
> >> >> >> >> > me
> >> >> >> >> > to insert a picture into a cell on the spreadsheet so that
> >> >> >> >> > mail
> >> >> >> >> > merge
> >> >> >> >> > will
> >> >> >> >> > automatically sort the pictures to the correct files along
> >> >> >> >> > with
> >> >> >> >> > the
> >> >> >> >> > rest
> >> >> >> >> > of
> >> >> >> >> > the data? Any input would be greatly appreciated, thanks!
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>
|
|
the picture is located in:
d:\\Documents and Settings\\LAPKAEM\\My Documents\\CDD Students\\Pictures\\
"Evan Lapka" wrote:
[Quoted Text] > when ALT-F9 is pressed, { MERGEFIELD IDPicture } appears, when ALT-F9 is
> pressed again, 265332.jpg" (without the quotation marks) appears along with
> the other desired information in other fields i.e. Name, Address, etc...
>
> { MERGEFIELD IDPicture } is set up as a field.
>
>
> "Peter Jamieson" wrote:
>
> > From what you say, I can only make guesses. I think you have not constructed
> > the fields the way that they need to be. Let's start with three ideas:
> > 1. this works for lots of people but...
> > 2. it is not yet working for you so...
> > 3. the problem is likely to be something really simple
> >
> > Let's try to go step-by-step...
> >
> > <<
> > > the word document has this in the space: { MERGEFIELD IDPicture}
> > >>
> >
> > Let's start with your field:
> > a. in Word, you see { MERGEFIELD IDPicture }
> > b. what do you see if you press Alt-F9? Do you see: "265332.jpg" ? (But
> > without the double-quote marks?)
> >
> > Which folder contains the file
> >
> > 265332.jpg
> >
> > ?
> >
> > Peter Jamieson
> >
> > "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> > news:CEB6138D-39C6-43F7-A886-4CEF02D29FD5[ at ]microsoft.com...
> > > the word document has this in the space: { MERGEFIELD IDPicture}
> > > And in the corresponding excel cell: 265332.jpg
> > >
> > >
> > >
> > > "Peter Jamieson" wrote:
> > >
> > >> OK, so when you Alt-F9 to display the "field results" you see something
> > >> like
> > >>
> > >> c:\\my id pictures\\mypicture.jpg
> > >>
> > >> Or what?
> > >>
> > >> You are welcome to despam my e-mail address (remove "KillmapS") and send
> > >> me
> > >> copies of your document !
> > >>
> > >> Peter Jamieson
> > >>
> > >>
> > >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> > >> news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
> > >> > Alrighty, I did what you said for number 1, and now the text is
> > >> > actually
> > >> > appearing where it should, my only issue now is that instead of the
> > >> > picture
> > >> > appearing in the space, only the file name is appearing.
> > >> >
> > >> > "Peter Jamieson" wrote:
> > >> >
> > >> >> OK,
> > >> >>
> > >> >> 1. you also need to uncheck Word Tools|Options|General|Web
> > >> >> options|Files|"Update links on save" and try again.(Even though what
> > >> >> you
> > >> >> are
> > >> >> doing has nothing to do with the Web)
> > >> >>
> > >> >> 2. You need to ensure that the { MERGEFIELD IDPciture } is a
> > >> >> /field/ -
> > >> >> use
> > >> >> ctrl-F9 to insert the special field code braces - typing them from the
> > >> >> keyboard doesn't work.
> > >> >>
> > >> >>
> > >> >> Peter Jamieson
> > >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
> > >> >> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
> > >> >> > It now reads "{ INCLUDEPICTURE
> > >> >> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
> > >> >> > \* MERGEFORMAT \d }" which is not what I initially entered.
> > >> >> >
> > >> >> > "Peter Jamieson" wrote:
> > >> >> >
> > >> >> >> While previewing the mail merge main document, use Alt-F9 to view
> > >> >> >> the
> > >> >> >> field
> > >> >> >> codes, then select { MERGEFIELD IDPicture }, right-click and select
> > >> >> >> the
> > >> >> >> Toggle field code option. You should now see the complete file path
> > >> >> >> name.
> > >> >> >> Apart from the doubled-up backslashes, is it /exactly/ the same as
> > >> >> >> the
> > >> >> >> actual full path name of one of your images? (No extra spaces at
> > >> >> >> the
> > >> >> >> beginning or end or around the file name, for example)
> > >> >> >>
> > >> >> >> Peter Jamieson
> > >> >> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in
> > >> >> >> message
> > >> >> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
> > >> >> >> > perhaps I'm not doing something right, but after I enter in
> > >> >> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
> > >> >> >> > \d }
> > >> >> >> > with
> > >> >> >> > the modified file parameters, etc... the text just disappears and
> > >> >> >> > no
> > >> >> >> > image
> > >> >> >> > is
> > >> >> >> > present.
> > >> >> >> >
> > >> >> >> > "Peter Jamieson" wrote:
> > >> >> >> >
> > >> >> >> >> Put the the full pathname of the ID picture in a cell in Excel
> > >> >> >> >> (you
> > >> >> >> >> may
> > >> >> >> >> also
> > >> >> >> >> have to double up any backslashes in the name, or use single
> > >> >> >> >> forward
> > >> >> >> >> slashes, e.g.
> > >> >> >> >>
> > >> >> >> >> c:\\my id pictures\\xyz.jpg
> > >> >> >> >> or
> > >> >> >> >> c:/my id pictures/xyz.jpg
> > >> >> >> >>
> > >> >> >> >> Let's suppose you put the filenames in a column called
> > >> >> >> >> IDPicture.
> > >> >> >> >>
> > >> >> >> >> Then use the following nested field in Word:
> > >> >> >> >>
> > >> >> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
> > >> >> >> >>
> > >> >> >> >> (both pairs of {} have to be the special field codes you can
> > >> >> >> >> insert
> > >> >> >> >> using
> > >> >> >> >> ctrl-F9)
> > >> >> >> >>
> > >> >> >> >> Alternatively, if all the pictures are in the same folder, say
> > >> >> >> >> c:\my
> > >> >> >> >> id
> > >> >> >> >> pictures, thenyou can put just the file name "xyz.jpg" in the
> > >> >> >> >> IDPicture
> > >> >> >> >> column and use
> > >> >> >> >>
> > >> >> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD IDPicture }"
> > >> >> >> >> \d }
> > >> >> >> >>
> > >> >> >> >> (Make sure there are no spaces that shouldn't be there).
> > >> >> >> >>
> > >> >> >> >> Then merge to a new document, ctrl-A to select it, and press F9
> > >> >> >> >> to
> > >> >> >> >> update
> > >> >> >> >> the fields to see the different pictures.
> > >> >> >> >>
> > >> >> >> >> Peter Jamieson
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in
> > >> >> >> >> message
> > >> >> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
> > >> >> >> >> > I'm currently working on a database of employees for my
> > >> >> >> >> > supervisor.
> > >> >> >> >> > I'm
> > >> >> >> >> > making individual profiles of employees by using the
> > >> >> >> >> > mail-merge
> > >> >> >> >> > feature
> > >> >> >> >> > in
> > >> >> >> >> > Microsoft word to take the data from the spreadsheet and
> > >> >> >> >> > filter
> > >> >> >> >> > it
> > >> >> >> >> > into
> > >> >> >> >> > word
> > >> >> >> >> > documents. This part is going wonderfully... BUT, my
> > >> >> >> >> > supervisor
> > >> >> >> >> > told
> > >> >> >> >> > me
> > >> >> >> >> > today
> > >> >> >> >> > that he wants ID pictures included with each profile. Is there
> > >> >> >> >> > a
> > >> >> >> >> > way
> > >> >> >> >> > for
> > >> >> >> >> > me
> > >> >> >> >> > to insert a picture into a cell on the spreadsheet so that
> > >> >> >> >> > mail
> > >> >> >> >> > merge
> > >> >> >> >> > will
> > >> >> >> >> > automatically sort the pictures to the correct files along
> > >> >> >> >> > with
> > >> >> >> >> > the
> > >> >> >> >> > rest
> > >> >> >> >> > of
> > >> >> >> >> > the data? Any input would be greatly appreciated, thanks!
> > >> >> >> >> >
> > >> >> >> >> >
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> >
> >
|
|
Then are you using
{ INCLUDEPICTURE "d:\\Documents and Settings\\LAPKAEM\\My Documents\\CDD
Students\\Pictures\\{ MERGEFIELD IDPicture }" }
?
Peter Jamieson
"Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
news:463B23F4-83FF-440B-AB4B-2188EAD1C2E4[ at ]microsoft.com...
[Quoted Text] > the picture is located in:
> d:\\Documents and Settings\\LAPKAEM\\My Documents\\CDD
> Students\\Pictures\\
>
> "Evan Lapka" wrote:
>
>> when ALT-F9 is pressed, { MERGEFIELD IDPicture } appears, when ALT-F9 is
>> pressed again, 265332.jpg" (without the quotation marks) appears along
>> with
>> the other desired information in other fields i.e. Name, Address, etc...
>>
>> { MERGEFIELD IDPicture } is set up as a field.
>>
>>
>> "Peter Jamieson" wrote:
>>
>> > From what you say, I can only make guesses. I think you have not
>> > constructed
>> > the fields the way that they need to be. Let's start with three ideas:
>> > 1. this works for lots of people but...
>> > 2. it is not yet working for you so...
>> > 3. the problem is likely to be something really simple
>> >
>> > Let's try to go step-by-step...
>> >
>> > <<
>> > > the word document has this in the space: { MERGEFIELD IDPicture}
>> > >>
>> >
>> > Let's start with your field:
>> > a. in Word, you see { MERGEFIELD IDPicture }
>> > b. what do you see if you press Alt-F9? Do you see: "265332.jpg" ?
>> > (But
>> > without the double-quote marks?)
>> >
>> > Which folder contains the file
>> >
>> > 265332.jpg
>> >
>> > ?
>> >
>> > Peter Jamieson
>> >
>> > "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> > news:CEB6138D-39C6-43F7-A886-4CEF02D29FD5[ at ]microsoft.com...
>> > > the word document has this in the space: { MERGEFIELD IDPicture}
>> > > And in the corresponding excel cell: 265332.jpg
>> > >
>> > >
>> > >
>> > > "Peter Jamieson" wrote:
>> > >
>> > >> OK, so when you Alt-F9 to display the "field results" you see
>> > >> something
>> > >> like
>> > >>
>> > >> c:\\my id pictures\\mypicture.jpg
>> > >>
>> > >> Or what?
>> > >>
>> > >> You are welcome to despam my e-mail address (remove "KillmapS") and
>> > >> send
>> > >> me
>> > >> copies of your document !
>> > >>
>> > >> Peter Jamieson
>> > >>
>> > >>
>> > >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in message
>> > >> news:168252EA-D381-410B-B94C-4C82BAC91147[ at ]microsoft.com...
>> > >> > Alrighty, I did what you said for number 1, and now the text is
>> > >> > actually
>> > >> > appearing where it should, my only issue now is that instead of
>> > >> > the
>> > >> > picture
>> > >> > appearing in the space, only the file name is appearing.
>> > >> >
>> > >> > "Peter Jamieson" wrote:
>> > >> >
>> > >> >> OK,
>> > >> >>
>> > >> >> 1. you also need to uncheck Word Tools|Options|General|Web
>> > >> >> options|Files|"Update links on save" and try again.(Even though
>> > >> >> what
>> > >> >> you
>> > >> >> are
>> > >> >> doing has nothing to do with the Web)
>> > >> >>
>> > >> >> 2. You need to ensure that the { MERGEFIELD IDPciture } is a
>> > >> >> /field/ -
>> > >> >> use
>> > >> >> ctrl-F9 to insert the special field code braces - typing them
>> > >> >> from the
>> > >> >> keyboard doesn't work.
>> > >> >>
>> > >> >>
>> > >> >> Peter Jamieson
>> > >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in
>> > >> >> message
>> > >> >> news:77738DD8-D955-4A97-BA7E-8AE25CF0D63B[ at ]microsoft.com...
>> > >> >> > It now reads "{ INCLUDEPICTURE
>> > >> >> > "Pictures/%7b%20MERGEFIELD%20IDPicture%20%7d"
>> > >> >> > \* MERGEFORMAT \d }" which is not what I initially entered.
>> > >> >> >
>> > >> >> > "Peter Jamieson" wrote:
>> > >> >> >
>> > >> >> >> While previewing the mail merge main document, use Alt-F9 to
>> > >> >> >> view
>> > >> >> >> the
>> > >> >> >> field
>> > >> >> >> codes, then select { MERGEFIELD IDPicture }, right-click and
>> > >> >> >> select
>> > >> >> >> the
>> > >> >> >> Toggle field code option. You should now see the complete file
>> > >> >> >> path
>> > >> >> >> name.
>> > >> >> >> Apart from the doubled-up backslashes, is it /exactly/ the
>> > >> >> >> same as
>> > >> >> >> the
>> > >> >> >> actual full path name of one of your images? (No extra spaces
>> > >> >> >> at
>> > >> >> >> the
>> > >> >> >> beginning or end or around the file name, for example)
>> > >> >> >>
>> > >> >> >> Peter Jamieson
>> > >> >> >> "Evan Lapka" <Evan Lapka[ at ]discussions.microsoft.com> wrote in
>> > >> >> >> message
>> > >> >> >> news:89029E04-E998-4C2A-815C-85C66185ADFF[ at ]microsoft.com...
>> > >> >> >> > perhaps I'm not doing something right, but after I enter in
>> > >> >> >> > { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD
>> > >> >> >> > IDPicture }"
>> > >> >> >> > \d }
>> > >> >> >> > with
>> > >> >> >> > the modified file parameters, etc... the text just
>> > >> >> >> > disappears and
>> > >> >> >> > no
>> > >> >> >> > image
>> > >> >> >> > is
>> > >> >> >> > present.
>> > >> >> >> >
>> > >> >> >> > "Peter Jamieson" wrote:
>> > >> >> >> >
>> > >> >> >> >> Put the the full pathname of the ID picture in a cell in
>> > >> >> >> >> Excel
>> > >> >> >> >> (you
>> > >> >> >> >> may
>> > >> >> >> >> also
>> > >> >> >> >> have to double up any backslashes in the name, or use
>> > >> >> >> >> single
>> > >> >> >> >> forward
>> > >> >> >> >> slashes, e.g.
>> > >> >> >> >>
>> > >> >> >> >> c:\\my id pictures\\xyz.jpg
>> > >> >> >> >> or
>> > >> >> >> >> c:/my id pictures/xyz.jpg
>> > >> >> >> >>
>> > >> >> >> >> Let's suppose you put the filenames in a column called
>> > >> >> >> >> IDPicture.
>> > >> >> >> >>
>> > >> >> >> >> Then use the following nested field in Word:
>> > >> >> >> >>
>> > >> >> >> >> { INCLUDEPICTURE "{ MERGEFIELD IDPicture }" \d }
>> > >> >> >> >>
>> > >> >> >> >> (both pairs of {} have to be the special field codes you
>> > >> >> >> >> can
>> > >> >> >> >> insert
>> > >> >> >> >> using
>> > >> >> >> >> ctrl-F9)
>> > >> >> >> >>
>> > >> >> >> >> Alternatively, if all the pictures are in the same folder,
>> > >> >> >> >> say
>> > >> >> >> >> c:\my
>> > >> >> >> >> id
>> > >> >> >> >> pictures, thenyou can put just the file name "xyz.jpg" in
>> > >> >> >> >> the
>> > >> >> >> >> IDPicture
>> > >> >> >> >> column and use
>> > >> >> >> >>
>> > >> >> >> >> { INCLUDEPICTURE "c:\\my id pictures\\{ MERGEFIELD
>> > >> >> >> >> IDPicture }"
>> > >> >> >> >> \d }
>> > >> >> >> >>
>> > >> >> >> >> (Make sure there are no spaces that shouldn't be there).
>> > >> >> >> >>
>> > >> >> >> >> Then merge to a new document, ctrl-A to select it, and
>> > >> >> >> >> press F9
>> > >> >> >> >> to
>> > >> >> >> >> update
>> > >> >> >> >> the fields to see the different pictures.
>> > >> >> >> >>
>> > >> >> >> >> Peter Jamieson
>> > >> >> >> >>
>> > >> >> >> >>
>> > >> >> >> >> "Evan Lapka" <EvanLapka[ at ]discussions.microsoft.com> wrote in
>> > >> >> >> >> message
>> > >> >> >> >> news:45E736BE-FEAC-4E3A-9852-2AE760C85805[ at ]microsoft.com...
>> > >> >> >> >> > I'm currently working on a database of employees for my
>> > >> >> >> >> > supervisor.
>> > >> >> >> >> > I'm
>> > >> >> >> >> > making individual profiles of employees by using the
>> > >> >> >> >> > mail-merge
>> > >> >> >> >> > feature
>> > >> >> >> >> > in
>> > >> >> >> >> > Microsoft word to take the data from the spreadsheet and
>> > >> >> >> >> > filter
>> > >> >> >> >> > it
>> > >> >> >> >> > into
>> > >> >> >> >> > word
>> > >> >> >> >> > documents. This part is going wonderfully... BUT, my
>> > >> >> >> >> > supervisor
>> > >> >> >> >> > told
>> > >> >> >> >> > me
>> > >> >> >> >> > today
>> > >> >> >> >> > that he wants ID pictures included with each profile. Is
>> > >> >> >> >> > there
>> > >> >> >> >> > a
>> > >> >> >> >> > way
>> > >> >> >> >> > for
>> > >> >> >> >> > me
>> > >> >> >> >> > to insert a picture into a cell on the spreadsheet so
>> > >> >> >> >> > that
>> > >> >> >> >> > mail
>> > >> >> >> >> > merge
>> > >> >> >> >> > will
>> > >> >> >> >> > automatically sort the pictures to the correct files
>> > >> >> >> >> > along
>> > >> >> >> >> > with
>> > >> >> >> >> > the
>> > >> >> >> >> > rest
>> > >> >> >> >> > of
>> > >> >> >> >> > the data? Any input would be greatly appreciated, thanks!
>> > >> >> >> >> >
>> > >> >> >> >> >
>> > >> >> >> >>
>> > >> >> >> >>
>> > >> >> >>
>> > >> >> >>
>> > >> >>
>> > >> >>
>> > >>
>> > >>
>> >
>> >
|
|
|