Replies

Thanks Wendell
The plan is to print all the records (75) from this report. This is an alternative solution to merging in Word.
The records with no data are pretty random so I cant go down that road.
The Can Shrink Can Grow idea you suggest doesn’t remove the labels though.
Is there a way to do this with code?

The document “WordMailmerge Tips and Trips” is excellent, however, I now have another problem which doesnt seem to be addressed in it.

I have a memo field in my database which I have set to be RTF format. I am using this in my mailmerge, however it is appearing in the document with the HTML showing. How do I get rid of this?

Guide for use:

Kind Regards
Kerry

Too easy!!! Thanks Paul.

Steve you are a marvel! I have had brain burn sorting this, but I think I have it right now. :huh:

You were right, my example was incorrect.

To help you get a picture of what I am trying to achieve I have been tasked with identifying all the assets in our department, which thousands of items. The sample I have given you is only a tiny part of the spreadsheet, but if I can get it working on this sample I can work it into my real data.

I have come into it when part of the work was done and not in a way I would have organised it. I created a master spreadsheet with all assets ie EXTRACT. The PC-Monitors-Phones spreadsheet was sent out to workers to identify these assets and put in their information. Sadly not much thought was given to how the information received back was going to be matched with the EXTRACT. To do this manually would take forever.

I have worked in your code and the example is attached. The only thing I dont understand is Column I on Extract (Ture or False). And a further thought is, how can a duplicate be identified?

Steve I apologise for my dreadful example. I have taken a fair amount of time putting together a better example of my issue. It is tricky when you have to de-identify data and keep the file size small.

In the attachment I want to search “PC-Monitors-Phones” for matching info to copy over to “Extract”. I have included some records showing examples in the first few rows of “Extract.”

In “PC-Monitors-Phones” search columns A,B,C,D,E for a match to “Extract” column A. When there is a match copy over the information from “PC-Monitors-Phones” Columns G,H,I,J,K and L to the corresponding columns in “Extract” I,J,K,L,M,N,O. Where there is no match the cell should be left blank.

Your help is always greatly appreciated.

Kerry

Thanks Steve and Zeddy both answers taught me something and got my brain working again. I love excel but dont get to use it often enough.

This one is going to be a bit of a challenge.

I want to add another complexity to my workings and are hoping you can help. I have attached a sample.
In Column E of the “Extract” sheet I want to check colum A – with Sheet “Printers” for a match in columns A or D – where there is a match copy the contents of the matching cells of “printers” to the Extract sheet Colum E. If there are matches in both A and D then it will require two colums.

Kerry

Hello Steve

Thank you for your reply. I cannot seem to make this work.
In my live version I have 766 possible cost centres that have to be searched through to match about 3000 rows in the Extract Worksheet. A cost Centre may be repeated in the Extract Sheet.

Thankyou Maud this is exactly what I was trying to do. I have expanded it to do a few more things as well.

Is there a way to add seconds to be calculated by the formula as well?

I am trying to calculate the duration between start and end time of running some reports.

Sorry I neglected to add that I am using Outlook 2003. I have hunted through tools options and cant locate anything there.

Dont worry – have found it – but the option is not allowed on our SOE.

Great idea thanks!

I ended up doing just that and it appears to have fixed the problem. Think I will give the Visio Beta version a big miss.

Thanks for assistance.

I get the same problem as in the posts you found. I can actually by pass it and open Outlook, but it is extremely annoying. I havent uninstalled visio yet. Do you think i should uninstall it?

Duh! Too simple. Why didnt I think of that. Thanks Hans.

Thankyou both for your replies. This gives me a great starting point and some thinking to do.
Much appreciated.