Re: Report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If your database field is a text data type and contains the filename,
rather than an OLE data type and contains a linked/embedded image then
Word would work best. If they were embedded/linked images then an
Access report would work best since Word does not support the OLE data
type in mail merge.

You're almost there, however you need to nest your merge field in an
IncludePicture field. It would look something like:

{ IncludePicture "C:\\Pictures\\{ MERGEFIELD DatabaseImageField}" }

Note the double backslashes in the path. To insert the field braces
({ }) press Ctrl + F9.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Skc" <Skc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FF90E81-8F57-469B-9E55-D23F45EF3742@xxxxxxxxxxxxxxxx
>I have a database which also contains the filename to an image, e.g.
> image.jpg. What I want to do it create brochures, so I can do a
> mailmerge -
> merge all the fields from the table into this page and also display
> an image
> on the page based on paths to the filename in a particular
> directory.
>
> So if my record has image.jpg, then I can modify this on the
> mailmerge so
> that it becomes c:\pictures\<<database image field>>.
>
> Do I use Word for this or Access? How do I do this and what are the
> pros
> and cons for doing this between Word and Access?
>
> thanks.


.

Relevant Pages

  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: runtime error with Mask edit control
    ... DateOfBirth property is a string. ... If no value is entered into the Property, the database stores a null. ... > its data type (one would assume the same as the property, ...
    (microsoft.public.vb.controls)
  • Re: Type Mismatch Error Message
    ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
    (microsoft.public.frontpage.programming)
  • Re: Search for columns in tables that are a specific data type?
    ... It may be more info than you want, but you can use the Database Documenter ... was the AutoNumber data type; it did get migrated as an Integer, ... I know how to do this in SQL but can't seem to find ...
    (microsoft.public.access.queries)
  • RE: function doesnt return value - SOMETIMES!
    ... It seems the calling stack has some issues. ... If not, I suggest that you create a new database, and import the ... |> thing I can see is that you are declaring 3 of your numerical values as ... |> when it does work correctly that would be because this data type is ...
    (microsoft.public.access.modulesdaovba)