Search the Community

Any sensible way of splitting a mail merge document. I need to save it out as separate files to send via parent mail. So far I see installers, addons and pdf splitter web program. I saw a tutorial on splitting headers in Youtube but it didn't work with our document. is there no native way of doing this without having to trust some obscure program from a random website. I couldn't find anything in the office store either.

Hopefully somebody might be able to point me in the right direction or has a clue what I am babbling about. As a mail merge setup is too difficult for some members of our Admin team to grasp the concept of, I thought that setting up the letter template in a report for SIMs might be more useful for them. So the setup is this. The letter template is ready to roll however the data required is captured from the report found in Reports - Attendance - Selected Pupil Reports - Pupils with Chosen Code Report. Is there any way to modify this report so that it can include pupil address, the selection of a date range and specifically the code 'L' for Late. Then using this to merge the data into the predefined word template? This would save a lot of time and hassle in the fact the 2 months later I would probably need to train the users on mail merging again. Any help will be greatly appreciated.

Basically I'd like to to pick up the nth to the (n+x)th characters in a document and have them replace LTrim$(Str$(Counter))in this line of a macro: DocName = "Myletter" & LTrim$(Str$(Counter)) Problem is, as someone who has only used VBA in Excel before - & is something of a novice there - I don't know the syntax or how to find out the character number of a particular bit of text. (Well, I could probably have a go at guessing the latter, but is a return a single character? or none? or 80?) And Word's own VBA help files & articles - on & offline - are still above my head. Why? I've a mail merge to generate a set of reports that should be uploaded to our Parent Information System (we use MCAS). To do that I need each student's page to be saved as a separate document when I run the merge. I've found a bit of code that does that, & even got it to work (more or less), but it saves each document with a title in the form "My Letterx" where x is , as you can see from the code, a counter. Now that's a step along the way, but I want the admin number or something so that I don't have to go through and manually rename each one before I upload it to the Bromcom DMS. The number is, of course, in the data source (a separate spreadsheet) and I'm hoping that if I insert it into the document right at the start as a merge field a solution along the lines of what I've asked for above would do the trick. Or would it just pick up the field reference?? Or is there a way of picking it up directly from the data source? I know that if we had all our assessment data in Bromcom or AM this could be done automagically, but ... *sigh* don't ask! Thanks in advance for any light anyone can shed on this.

Hey Everyone At our school we currently have a excel spreadsheet for tracking educational visits that all teachers can access and add their trip info which then gets merged across to a word document that they take out with them. Is there anyway to do this as a shared document on office 365 as we have been experiencing issues where users keeping getting the locked for editing message and we want to find a better way to do it. I know mail merge in O365 Online is not a thing right now? Thanks Dan

I have an Excel report output from our MIS which shows incidences recorded for staff. Column 1 shows the name of the staff member with column 2 showing each incident recorded. At the moment my mail merge will produce a separate letter for each incident...meaning that I have multiple letters for some...I'd prefer to be able to merge several rows into one doc if possible ( i.e. name appears once with pertinent column 2 incident entries). Simplest solution possible appreciated.

Hi guys, i hope this make sence i've been asked to do some labels for our canteen. im putting the items they sell in an excel sheet to do a mail merge. the typical way of Mail Merge is 1 row = 1 label... is it possible to have 1 record = 1 page of labels. i know i could just copy the correct about of records in excel but that seems terrible inefficient thanks jack