Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: Adding an image to mail merge

    Hi,

    I have some code to create a mail merge letter.
    The end user also wants to add their signature onto the letter so they don't have to sign 300+ letters.
    I have asked them to scan in their signature and save it as an image.

    I have tried doing it in a template, but whenever I perform the mail merge the image gets pushed down the page after the text.

    I have seen on various sites I can use the following in Word to add an image to a mail merge:

    {IncludePicture "E:\\Temp\\{Mergefield FirstName}{Mergefield LastName}.jpg"}
    Can I use the same code above in my Access code when performing the mail merge, if so what function or property would I have to use?

    Could I simply use the TypeText property?

    Thanks

  2. #2
    Join Date
    Sep 2005
    Posts
    240
    I have found a solution by using:

    Code:
    objWord.Shapes.AddPicture
    But it ends up at the top of the page.
    If I specify a range in the anchor it will position it where I want, but I can't find out what is meant to be used as the range, is it co-ordinates for the top and left of the page, how many rows down you would like to place the image or something else?

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    sorry that i can't help, but i do have a naïve question:
    what does Word bring you that Access reports don't?

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •