Mail Merge Headache

[PeteB]

Hi Guys

Can anyone help with my mail merge headache?

I had planned to do a mail merge starting with a Word main document and an Access database query as the data source, then moving into Outlook as the mail handler.

In preparation, I created the Access query which filtered out all but the four fields of MemNumber, Title, LastName and e-mail address. Although the query contained multiple criteria, it was neither a parameter query nor an action query - its function was simply to identify members who had e-mail but who did not subscribe to the e-newsletter.

The problem arose when, from the Word 'Mailing' tab, choosing ‘Select Recipients/Use an Existing List’ the list of available objects presented did not include the filtering query.

Can anyone suggest the likely cause and a solution?

Your help would be much appreciated.

PeteB

 

[isladogs]

What is the row source for your combo box/ listbox?

 

[Gasman]

Hmm, mine only shows me queries and any local tables.?
You can also filter within the merge?

 

[mike60smart]

Hi Pete

Why not use a Report in Access vice the Word Document?

 

[isladogs]

As an alternative approach, have a look at Albert Kallal's super easy mail merge which is all controlled from Access.
A Web search will give lots of hits to this code. Very easy go use and works well

 

[Yianni]

Why not use a make table query?

 

[PeteB]

Thanks guys. I'll see what I can make of all of the responses.
PeteB

 

[Isaac]

@PeteB
Can you post the SQL of the query that you wish to use as the source?

 

[Yianni]

There is no SQL as the source. The question involved a compiled. Library that I could reference in my Access program. Thanks
John

 

[Isaac]

There is no SQL as the source. The question involved a compiled. Library that I could reference in my Access program. Thanks
John

@Yianni ... I think you might have thought you were responding to another thread ...

 

[Isaac]

Yeah that's kind of the road I was going down - and there are a few other things that OLEDB cannot interpret properly that might cause his original problem. Was hoping OP would post the query so we'd know.