Handling SPACE in [SQLstatement] argument during mailmerge

[Zlll]

Below is my vba code for calling a mailmerged word doc with data filtred for any cell under the [Status] column that contains the value 'Pending report'.

These code resulted in infinite loop of error "Excel is waiting for another application to complete an OLE action".

However, if the value to be matched is changed to one that does NOT contain any SPACE e.g. WHERE [Status] = 'Done', everything's fine.

I attempted to handle the SPACE with the following ways but to no avail:

• 'Pending'&' '&'report'
• [Pending report]
• '"Pending report"'
• 'Pending%report'
• ""Pending report""

I have try googling the solution for the whole day Any help would be much appreciated!

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.

[Zlll]

Try

Please Login or Register  to view this content.

Thanks but still doesnt work...
I guess I might at the end remove the space from the values of those affected cells.

[macropod]

The error message has nothing to do with your SQL syntax or an infinite loop but with the fact your macro is waiting for someone to respond to the SQL prompt Word generates when opening a mailmerge main document - which is why you're getting that particular error message.

The following macro shows how you might prevent that issue arising - and generate a separate output file for each merged record as a Word document and/or pdf. You could, of course, omit that extra functionality.

Please Login or Register  to view this content.