Mail merge and pictures

GrumbleDook · 27-10-2005, 08:59 PM

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!!!

mark · 27-10-2005, 09:12 PM

googled these:

http://www.computorcompanion.com/LMMArticle.asp?ID=126

http://groups.google.com/group/micro...ontextures.com

alan-d · 31-10-2005, 12:12 PM

What version of SIMS?

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

GrumbleDook · 31-10-2005, 06:20 PM

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.

Ric_ · 31-10-2005, 07:13 PM

@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

GrumbleDook · 31-10-2005, 08:59 PM

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 ...

alan-d · 01-11-2005, 09:30 AM

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.

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

27-10-2005, 08:59 PM	#1
GrumbleDook Join Date: Jul 2005 Location: Kettering, Northants Posts: 5,118 Thanks: 54 Thanked 206 Times in 110 Posts Blog Entries: 1 Rep Power: 55	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!!!

27-10-2005, 09:12 PM	#2
mark Join Date: Jun 2005 Location: x-communicated Posts: 3,707 Thanks: 37 Thanked 14 Times in 12 Posts Blog Entries: 2 Rep Power: 18	Re: Mail merge and pictures googled these: http://www.computorcompanion.com/LMMArticle.asp?ID=126 http://groups.google.com/group/micro...ontextures.com

31-10-2005, 12:12 PM	#3
alan-d Join Date: Aug 2005 Location: Sutton Coldfield Posts: 1,272 Thanks: 22 Thanked 15 Times in 15 Posts Rep Power: 13	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.

31-10-2005, 06:20 PM	#4
GrumbleDook Join Date: Jul 2005 Location: Kettering, Northants Posts: 5,118 Thanks: 54 Thanked 206 Times in 110 Posts Blog Entries: 1 Rep Power: 55	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.

		EduGeek.net Forums > Technical > Educational Software
Mail merge and pictures

31-10-2005, 07:13 PM	#5
Ric_ Join Date: Jun 2005 Location: Lancashire Posts: 5,578 Thanks: 30 Thanked 151 Times in 132 Posts Rep Power: 44	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

31-10-2005, 08:59 PM	#6
GrumbleDook Join Date: Jul 2005 Location: Kettering, Northants Posts: 5,118 Thanks: 54 Thanked 206 Times in 110 Posts Blog Entries: 1 Rep Power: 55	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 ...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge	Teaboy	MIS Systems	4	12-11-2007 07:32 PM
Mail Merge Office 2003	karldenton	Windows	5	18-06-2007 08:26 AM
Office 2k3 "Insert Image from File" and "Mail Merge" prob	Gatt	Windows	6	28-09-2006 07:06 PM
...remove shortcut to Sample Pictures	markesmith	How do you do....it?	7	03-07-2006 09:01 PM
Mail Merge with Office 2003	luke213	Windows	1	19-01-2006 11:33 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

Register now for FREE and post messages!
Username: Password: Confirm Password: E-Mail: Confirm E-Mail: Birthday: Image Verification I agree to forum rules

Educational sofware forum sponsored by