+ Post New Thread
Results 1 to 12 of 12
Educational Software Thread, Mail merge and pictures in Technical; Perhaps I am banging my head against a brick wall here ... I would like to take a word document. ...
  1. #1

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,935
    Thank Post
    1,341
    Thanked 1,784 Times in 1,107 Posts
    Blog Entries
    19
    Rep Power
    595

    Mail merge and pictures

    Perhaps I am banging my head against a brick wall here ...

    I would like to take a word document.

    I would like to merge into it data from an excel spreadsheet.

    However, one of the fields is the location of a picture (student piccies) and I would like to insert the picture in rather than just "d:\pics\008789.bmp" (which doesn't really work anyway as the mail merge strips out the punctuation)

    Any ideas on this?

    Oh yeah ... it is for printing off at 9 am tomorrow morning, all because SIMS won't flippin' do it!!!

  2. #2
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,966
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

  3. #3
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75

    Re: Mail merge and pictures

    What version of SIMS?

    SIMS.Net will allow it via the reports. Just create one including the field containing the picture.

  4. #4

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,935
    Thank Post
    1,341
    Thanked 1,784 Times in 1,107 Posts
    Blog Entries
    19
    Rep Power
    595

    Re: Mail merge and pictures

    Yep ... tried that ... if you take the standard report and try and doctor it to get what I want if fails to put in the picture ( an known feature apparently due to the way office 2002 and upwards deal with the INCLUDEPICTURE code to try and prevent malicious pictures running nasty code ... even though lots of places have it all working Capita don't like it and so tell you to bugger off.

    Strangely they do say that there are several commenrcial packages out there that will do exactly what we want ... and that we should by into it.

    We sort of have it sorted now though, thanks to Mark and thanks to Stephen ... the final merge not only needs to be load into a new document it needs to be refreshed again afterwards to make sure there is an different picture in each record.

    Now all I need to do is print them off and laminate then ... it is almost worth the cost of going for a commercial package to save the time, hassle and make it easy for a non-techie person just to select the studnet and click print.

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    Re: Mail merge and pictures

    @GrumbleDook: If the problem is with Office, why not try it with a superior product Can't think of one off the top of my head

  6. #6

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,935
    Thank Post
    1,341
    Thanked 1,784 Times in 1,107 Posts
    Blog Entries
    19
    Rep Power
    595

    Re: Mail merge and pictures

    I did ... I used my mac and Automator and can get what I want very easily ... the idea is to have it so that is a duplicate lunch pass is needed it can be run of by one of the student office staff and is linked to our MIS so we are not having to change student information in yet another database.

    That is why I wanted it in SIMS.

    It is sorted for the moment ... but I will be looking for alternatives around February next year ...

  7. #7
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75

    Re: Mail merge and pictures

    Quote Originally Posted by GrumbleDook
    Yep ... tried that ... if you take the standard report and try and doctor it to get what I want if fails to put in the picture ( an known feature apparently due to the way office 2002 and upwards deal with the INCLUDEPICTURE code to try and prevent malicious pictures running nasty code ...
    Strange - we use Office 2003 and it works fine :? Mind you we didn't doctor a standard report we created one from scratch.

  8. #8
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,009
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108
    Ok I am going to dig this old post up because I want to do something similar but cant get it to work. I want to have a sheet of information on a pupil which will merge in from SIMS and the rest will be filled in by hand. I want the students photo on this though but I cant get it to work.
    The only way I can get photos to show up is to use a word list but that does not produce the kind of output I want as it just plonks the photo in the first box per record. I want it to go where I tell it to. I am ready to delve into VBA if I need to. I just need pushing in the right direction first.

    Thanks in advance

    Chris

  9. #9

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Quote Originally Posted by ChrisH View Post
    Ok I am going to dig this old post up because I want to do something similar but cant get it to work. I want to have a sheet of information on a pupil which will merge in from SIMS and the rest will be filled in by hand. I want the students photo on this though but I cant get it to work.
    The only way I can get photos to show up is to use a word list but that does not produce the kind of output I want as it just plonks the photo in the first box per record. I want it to go where I tell it to. I am ready to delve into VBA if I need to. I just need pushing in the right direction first.

    Thanks in advance

    Chris
    I have done something similar using RTF reports IIRC

    http://www.eiskent.co.uk/SIMSQuickRe...0Templates.pdf

  10. #10

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,287
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162
    No help I am afraid but we have had no end of problems with pictures in Mailmerges. One of the teaching modules here has it in as they create their own top trump cards but it has always been hit and miss on whether the picture comes in at all or whether it gets updated properly. Often they would get the same picture on each merge.

  11. #11
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,009
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108
    Quote Originally Posted by jcollings View Post
    I have done something similar using RTF reports IIRC

    http://www.eiskent.co.uk/SIMSQuickRe...0Templates.pdf
    Thanks this has got me somewhere. Just need to find out why the word tables keep breaking after the first student.

  12. #12
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,009
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108
    Ok fixed the tables, just need to find why it ignoring page breaks grrrrr.

SHARE:
+ Post New Thread

Similar Threads

  1. Mail Merge
    By Teaboy in forum MIS Systems
    Replies: 4
    Last Post: 12th November 2007, 06:32 PM
  2. Mail Merge Office 2003
    By karldenton in forum Windows
    Replies: 5
    Last Post: 18th June 2007, 08:26 AM
  3. Replies: 6
    Last Post: 28th September 2006, 07:06 PM
  4. ...remove shortcut to Sample Pictures
    By markesmith in forum How do you do....it?
    Replies: 7
    Last Post: 3rd July 2006, 09:01 PM
  5. Mail Merge with Office 2003
    By luke213 in forum Windows
    Replies: 1
    Last Post: 19th January 2006, 10:33 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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