Replies

Hi Andrew

I have tested it and it works fine!

Thank you again.

Regards
useful

Thank you Andrew.

I will try this code in the morning, although I don’t pretend to understand what you mean by ‘recreate the macro so it is less dependent on cursor location’.

Regards
useful

Thank you for the explanation Andrew – so that’s why the macro is not on the Add-ins tab!

Unfortunately for me, I can’t really write VBA code, I just recorded those macros, so as a result I don’t really know what to do with the code you so kindly pointed me to.

All I want to do is to add the new macro to the Add-ins tab, with an icon, just like the other two macros already there. I don’t really want to add another Toolbar, nor do I have a machine that is running Word 2002 any longer.

In that case, which part of the code do I use?

Thank you in advance.

Regards
useful

Hi RetiredGeek, thank you for the follow-up.

I forgot to elaborate that I created this template years ago and since converted to Word 2010 and expected to see the new macro I created on the Add-ins tab and it wasn’t there.

The template is attached.

Thank you in advance.

Regards
useful

Thanks for your response RetiredGeek, glad you are still providing your valuable assistance!

This macro is a Sub, just like the other two macros that do appear on the Add-ins tab.

Regards
useful

Thanks for the suggestion Joe.

This is one of the first things I tried, but it made no difference. Clearly Outlook is enumerating the sub-folders, that’s what I called ‘indexing’. How can I switch this off? It’s not happening with anyone else’s Outlook that I know, even people with much larger PST files.

Regards
useful

I have uninstalled MS Office Professional Pro and installed MS Office Home & Business, but it behaves exactly the same. pfbackup still doesn’t work!

useful

RetiredGeek, as usual, your solution is neat and clever!

Thank you very much, you have saved me hours of work!!

Regards
useful

Perhaps I should clarify the situation and what I am trying to achieve.

I have several folder trees each containing many sub-folders, say A, B, C, D and so on. The names of the sub-folders are mostly the same between the various folder trees, although there could be an X, Y, Z in one folder tree and not in others, or only 20 sub-folders in one folder tree and 40 in another.

Each sub-folder contains many files, most of which are the same as those in other sub-folders of the same name. For example, folder A in one tree may have 50 files, 40 of which are the same as sub-folder A located in another folder tree.

What I am trying to achieve is a single ‘master’ folder tree containing all of the sub-folders in each of the existing folder trees, each sub-folder containing all of the files in all of the sub-folders of that name, without any sub-folders or files in each sub-folder duplicated.

I can achieve exactly this by manually moving files to the corresponding sub-folder in the ‘master’ folder tree, clicking ‘move and replace’ and ticking ‘do this for the next x conflicts’, but it is tedious and very time consuming.

I hope this sets out the challenge more clearly.

Thank you again, in anticipation that someone will know how to automate this otherwise laborious process.

useful

Just letting you all know that I solved my problem by uninstalling and re-installing the software … I have no idea why it failed, but rather than spend more time trying to figure it out, I just re-did it and it now works fine.

Thank you.
useful

Thanks for the response bigdave99.

As you can see from the previous post, I have now set up a macro to do the printing, but this commercial software looks great! If I get stuck again, I will certainly give it a shot.

Thanks again.

Regards
useful

Thank you very much RetiredGeek and jjfreedman.

I have tested the code (from RetiredGeek plus the vital addition from jjfreedman) with the appropriate printer and it works like a charm!!

I’m very grateful to you both for your prompt attention and invaluable help!

Regards
useful

Hi RetiredGeek

Thank you for your prompt response and the code.

I will try going back to my original technique of not having ‘Different First Page’ checked and setting up the first page with the letterhead, make a second page with a Section Break Next Page and set different margins, headers and footers in a macro and hopefully your print code will print all pages from the right bins.

I will have to test this with just the letterhead page and see if that works too.

I’ll post again and let you know.

Thanks again.

Regards
useful

Hi RetiredGeek

I’m grateful for your response and the code.

Unlike Kim, I am unable to actually write VBA, so I’m not sure how or where to put the tray selection code and whether once that code is inserted, whether the print macro will run as you wrote it, or whether you intended that I print page one with the first part, then run the second part as another macro to print page 2 onwards?

As you can see, I really have no idea.

Also, Kim correctly pointed out that by using the ‘Different First Page’ technique, my Section Break Next Page tells Word that the second page is essentially also a first page (of the next section), which is why I am getting letterhead paper for the first two pages. Does your code overcome this?

I would be extremely grateful if you could send me the required code complete with paper tray selections, so I don’t mess it up (the code 256 selects the letterhead paper tray and the code wdPrinterUpperBin selectes the plain paper tray).

Thank you very much.

Regards
useful

Hi Kim

Thank you for your response.

What you say makes perfect sense. That explains it!

I have ‘Different First Page’ set because the first page is a printed letterhead with different margins and header/footer size and the subsequent pages plain with different margins and header/footers.

When I didn’t have it set and just made a second page with a section break next page and set margins, headers and footers in a macro, the third page inexplicably printed from the letterhead paper tray.

How else can I do this? It seems so simple, but I’m struggling with it.

Thank you.
useful