Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers,microsoft.public.word.tables
external usenet poster
 
Posts: 49
Default Include a Picture Field

I have data in excel from which i'm creating many mail merges - Included in
each record/row is a field containg the clients passport photo which I would
like to include in the mail merge

Any Ideas?

I cant use Access because it's not on most machines but if ness i can easily
move the data source from excel to MS Word table

  #2   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers,microsoft.public.word.tables
external usenet poster
 
Posts: 6
Default Include a Picture Field

What I've done in such cases is to include a mergefield with just the
filename of the photo, which is stored elsewhere. Then I use an
IncludePicture field with the full path of the folder where the folders are
stored, using the merge field as the last portion of that path. If the photo
itself is actually stored in Excel (is that possible?), then a mergefield
referencing that field should bring in the photo.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"JethroUK©" wrote in message
...
I have data in excel from which i'm creating many mail merges - Included

in
each record/row is a field containg the clients passport photo which I

would
like to include in the mail merge

Any Ideas?

I cant use Access because it's not on most machines but if ness i can

easily
move the data source from excel to MS Word table


  #3   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers,microsoft.public.word.tables
external usenet poster
 
Posts: 49
Default Include a Picture Field

They are currently stored in XL but i'll give that a try thanx


"Suzanne S. Barnhill" wrote in message
...
What I've done in such cases is to include a mergefield with just the
filename of the photo, which is stored elsewhere. Then I use an
IncludePicture field with the full path of the folder where the folders
are
stored, using the merge field as the last portion of that path. If the
photo
itself is actually stored in Excel (is that possible?), then a mergefield
referencing that field should bring in the photo.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"JethroUK©" wrote in message
...
I have data in excel from which i'm creating many mail merges - Included

in
each record/row is a field containg the clients passport photo which I

would
like to include in the mail merge

Any Ideas?

I cant use Access because it's not on most machines but if ness i can

easily
move the data source from excel to MS Word table



  #4   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers,microsoft.public.word.tables
external usenet poster
 
Posts: 7
Default Include a Picture Field

See http://www.gmayor.com/mail_merge_graphics.htm

--
<< << << << << << <<<
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<< << << << << << <<<

JethroUK© wrote:
They are currently stored in XL but i'll give that a try thanx


"Suzanne S. Barnhill" wrote in message
...
What I've done in such cases is to include a mergefield with just the
filename of the photo, which is stored elsewhere. Then I use an
IncludePicture field with the full path of the folder where the
folders are
stored, using the merge field as the last portion of that path. If
the photo
itself is actually stored in Excel (is that possible?), then a
mergefield referencing that field should bring in the photo.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"JethroUK©" wrote in message
...
I have data in excel from which i'm creating many mail merges -
Included in each record/row is a field containg the clients
passport photo which I would like to include in the mail merge

Any Ideas?

I cant use Access because it's not on most machines but if ness i
can easily move the data source from excel to MS Word table



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I include a picture in a formula i.e. if cell a26 >90% then s. PACF Excel Discussion (Misc queries) 24 December 6th 07 10:29 PM
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 03:48 PM
Code to include a one-up suffix to a field value Doctorjones_md Excel Discussion (Misc queries) 4 January 4th 07 06:18 PM
Code to include a one-up suffix to a field value Doctorjones_md Excel Worksheet Functions 4 January 4th 07 06:18 PM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"