Mail Merge from Excel?

Oh no! What's that?

Craig, welcome to the Forum! It is easy for a beginner to forums not to notice all of the rules. Rule 3 that requires code tags around code makes the forum better and helps us help you more easily. Plus, it just looks better. Some posts have hyperlinks that may not be all that easy to notice that it is a link. Forum Rules is also linked in the next to last tab left of the Log Out tab. The link is: http://www.excelforum.com/forum-rule...rum-rules.html

I don't normally get that verbose about code tags but thought that it might help you. I normally use the advanced mode so clicking # is easy but then I am lazy.

For your solution, I will look at it later today. For one thing, I noticed that you are using Word's wd constants. You need to set a Reference to the Word object if you want to use those or in MSWord's VBE Immediate Window type ?wdSendToPrinter and press Enter to get the numerical value and use that directly or define it in a variable.

The way that I have done this sort of thing in past projects was to record a macro in MSWord and then adapt it to Excel using the prefix objects in a way similar to what you have. Yes, I do think that your SQL string needs work.

One nice thing about this forum is that it lets you attach files. Simple example files helps those that help you all the better which is good for both parties.

So, don't ask RoyUK for help I guess.

Thank you Kenneth, as I'm sure you can tell I'm fairly new to this and have pieced that code together. I have turned on the Word Reference in VBA. I orginally had code that did what I wanted it to in Word but I was trying to remove that step. I didn't realise I could edit it and use it in Excel.

I've attached the two files I'm trying to do this with.

Thanks

Roy does a fine job as both moderator and problem solver. His first duty though is to moderate. Some like snb and myself might mention an infraction just to help the moderators out but we don't go into much detail sometimes, just a friendly reminder.

I will check back late this afternoon or earlier if I get my honey-dos done early and work on the problem if no one has solved it first. This is one of the best forums so a solution is definitely possible and most likely today.

cheers

Kenneth, you are a legend! I went back to my original code in Word, as you suggested, and got it working! Thank you for pointing me in the right direction :D

The problem with that is word remembers the database explicitly and staff take a copy of these files and move them hence the drawn out process

But, I don't know where they'll save it so it has to be a relative reference to the .xlsm That's why I've had to use the code to specify the link so if other teachers save it on pen drives, network drives, their desktop, at home etc it'll still work.

If you don't mind, can you post your code for others to learn?

A few years ago, I did a macro where I changed the data source but it was all in MSWord VBA.

Please Login or Register  to view this content.

Thanks snb but it's working fine so I'll leave it the way it is.