Recent content by HappyChap

Hello I'm really new to this so please treat me gently and please be aware that my knowledge of the correct terminology may not be 100% accurate but I do hope that you will afford me some understanding because of that. I’ve downloaded the Super Easy Mail Merge...

Can you help please ?

Hello ypma Thanks for that suggestion, not ideal, but I may consider it if I can't get a (with respect) more appropriate solution. Thanks for your help and time. Best wishes

Hello ypma I have entered the Booking Reference (eg 13012) into the criteria of the query and when I run the query, it brings up just that record. I've also entered the criteria [forms]![Reservations2]![Booking Reference] into the criteria of the query and when I run the query, it too brings...

Yes, I agree. I set up the new document but when it came (via the Mail Merge Helper) to open the data source, it brings up the prompt box asking "Enter Parameter Value" for [forms]![Reservations2]![Booking Reference]. To be able to enter a booking reference in the query, per the suggestion...

Thanks for that...I didn't think the SQL statement needed changing but I am very new to all of this so thought I'd better check. Thanks for the link, I've seen that and used that code (hence the same name of "MergeIt()") to create my code. I've tested the code and all it does is bring up...

Thanks ypma, I've changed the connection to: objWord.MailMerge.OpenDataSource _ Name:="H:\enjoy120210\Reservations.mdb", _ LinkToSource:=True, _ Connection:="QUERY MasterDataSource", _ SQLStatement:="SELECT * FROM [MasterDataSource]" ...so that should crack that. I've...

Thanks ever so ypma for your reply; I'm glad I'm on the right tracks in setting up the query. I've entered the booking reference and clicked OK and it then prompts me for the booking reference again. Once I click OK, it performs the mail merge and I get the mail merged document for that...

Thanks Rx Sorry if I'm being thick (but still happy !) here but where are you pointing me to for help please ? Thanks

I hope someone can help; furthermore, please be aware that my knowledge of the correct terminology may not be 100% accurate but I do hope that you will afford me some understanding because of that. I am using Word and Access 2000. I have created some code (linked to a command button on a...

I hope someone can help; furthermore, please be aware that my knowledge of the correct terminology may not be 100% accurate but I do hope that you will afford me some understanding because of that. I am using Word and Access 2000. I have created some code (linked to a command button on a...