Re: merge a photo from access database into word

From: Frank Haschka (anonymous_at_discussions.microsoft.com)
Date: 03/02/04


Date: Tue, 2 Mar 2004 04:28:46 -0800

Many thanks!
It's all working now. It baffles me how the refresh works
AFTER the merge, but it works, and that's good enough for
now!

F
 
>-----Original Message-----
>Use Alt+F9 to toggle on and off the field codes. Or use
Ctrl+F9 to insert
>and empty pair of field delimiters { } then manually
enter the text
>INCLUDEPICTURE etc.
>
>--
>Please post any further questions or followup to the
newsgroups for the
>benefit of others who may be interested. Unsolicited
questions forwarded
>directly to me will only be answered on a paid consulting
basis.
>Hope this helps
>Doug Robbins - Word MVP
>"Frank Haschka" <anonymous@discussions.microsoft.com>
wrote in message
>news:505a01c3ffa4$b8837c10$a101280a@phx.gbl...
>> I've read this thread with great interest as the end
>> result originally requested is precisely what I need to
>> achieve. However, please pardon this ridiculous
question.
>> How do you get the 'IncludePicture' field in to the
>> document in the first place, to then nest the
mergefield?
>> (as suggested in Cindy Meister's site). 'Help' suggests
>> just 'Insert/ Picture from file' and link to file, but
>> then how do I see the code and adjust it? A very new
area
>> for me, so my apologies for the daft query!
>>
>> I'm stuck with Office '97 by the way.
>>
>> Cheers
>> FH
>>>-----Original Message-----
>>>Yes, in the database you will need as a minimum, the
>> filename for the
>>>picture. If that is all that you have there, you will
>> need to supply the
>>>path in the Mergefield and note that the path separators
>> must be doubled \\
>>>
>>>Did you follow Step 5 of Cindy's instructions - updating
>> the fields in the
>>>document after the merge?
>>>
>>>Also, you must use Ctrl+F9 to insert each pair of field
>> delimiters { }.
>>>Ordinary curly brackets will not work.
>>>--
>>>Please post any further questions or followup to the
>> newsgroups for the
>>>benefit of others who may be interested. Unsolicited
>> questions forwarded
>>>directly to me will only be answered on a paid
consulting
>> basis.
>>>Hope this helps
>>>Doug Robbins - Word MVP
>>>"jon" <anonymous@discussions.microsoft.com> wrote in
>> message
>>>news:E579B081-F130-4CEC-9C5E-
CF1CDF3C4FCF@microsoft.com...
>>>>
>>>> Thank you for the reply, unfortunately it hasn't
>> worked. I have Office
>>>> XP. When i follow the instructions for Includepicture,
>> immediatly after I
>>>> insert the field everthing disappears. Additionally, I
>> have tried using
>>>> the insertpicture option but I get an error messsage
>> when i merge.
>>>> In the access table field i have the name of the
>> picture and have its
>>>> properties set to text, Is this correct for the merge.
>>>>
>>>> Thank you,
>>>>
>>>> Jon
>>>>
>>>> ----- Doug Robbins - Word MVP - DELETE UPPERCA
>> wrote: -----
>>>>
>>>> See the "Graphic from a database" item under
>> the "Special merges"
>>>> section of
>>>> fellow MVP Cindy Meister's website at:
>>>>
>>>>
>> http://homepage.swissonline.ch/cindymeister/MergFram.htm
>>>>
>>>> --
>>>> Please post any further questions or followup to
>> the newsgroups for
>>>> the
>>>> benefit of others who may be interested.
>> Unsolicited questions
>>>> forwarded
>>>> directly to me will only be answered on a paid
>> consulting basis.
>>>> Hope this helps
>>>> Doug Robbins - Word MVP
>>>> "jon" <anonymous@discussions.microsoft.com> wrote
>> in message
>>>> news:05d101c3ff15$0b2f2120$3501280a@phx.gbl...
>>>> > Is it possible to merge a photo that is in an
>> access
>>>> > table database into a word document using mail
>> merge?
>>>> > When I attempt it, it merges a number only?
Thank
>> you!
>>>> >> Jon
>>>>
>>>>
>>>>
>>>
>>>
>>>.
>>>
>
>
>.
>



Relevant Pages

  • Re: Return value for wdDialogInsertHyperlink show
    ... >directly to me will only be answered on a paid consulting ... >> I'm certainly willing to try this, but my VBA help shows ... >> newsgroups for the ... >> basis. ...
    (microsoft.public.word.vba.general)
  • Re: C interface with Java
    ... You are digging yourself deeper and deeper. ... NOBODY is coming to your defence or to your aid. ... If you are as familiar with newsgroups as you ... http://mindprod.com Java custom programming, consulting and coaching. ...
    (comp.lang.java.programmer)
  • Re: Sending document as email or copy to outlook in html format
    ... >Doug Robbins - Word MVP ... >> formatting in word when the document contents are placed ... >> newsgroups for the ... >> basis. ...
    (microsoft.public.word.vba.general)
  • Re: Cant Update Records
    ... >Thanks John, ... I'd be willing to do so, but only at my current consulting rates. ... a self-employed database design consultant, ... the newsgroups is risky - viruses and spammers regularly harvest them. ...
    (microsoft.public.access.forms)
  • Re: How to use calc age from parent form and subform?
    ... do the MVPs here do consulting - I need some help on a fairly complex ... With one exception, though, we don't solicit ... There are numerous websites for posting job offers - Monster.com for ... newsgroups is probably a good choice, ...
    (microsoft.public.access.forms)

Quantcast