Mail Merge with Access

[dniezby]

Would love to hear some opinions on how I might best pull this off.



I'm building an application that will have some prewritten mail merge emails. I will point it to one of my tables "subscribers".

Let's say I have a table with subscribers. I have 4 fields.

First, Last, email, subscriber

I want my user to be able to open one of my prewritten mail merge documents and email it to a list HOWEVER - if subscriber = NO then I want it to skip that record.

Is this even possible?

Hope to hear your ideas on how I might be able to get this to work.

Thanks in advance.

[alansidman]

Maybe this way:

http://www.datapigtechnologies.com/f...mailmerge.html

[dniezby]

That's a good start. I totally blanked on just creating a query and using that query as my data file. Thanks for that video. I'll watch the rest of it for more ideas.