Mail Merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Yes I know it has been asked and answered a lot of times but im not sure,
after reading these posts that my problem is here.

I have created a query that updates according to the date so i can mail
merge wheel alignment reminders for our customers.
I have only found code in this site that allows to mail merge one record at
a time.
How can I have them all come up at once or automate one at a time?

David
 
David said:
Yes I know it has been asked and answered a lot of times but im not
sure, after reading these posts that my problem is here.

I have created a query that updates according to the date so i can
mail merge wheel alignment reminders for our customers.
I have only found code in this site that allows to mail merge one
record at a time.
How can I have them all come up at once or automate one at a time?

David
Click to expand...

Hi David,

Have you looked at Albert Kallal's "Super Easy Word Merge" at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

HTH
 
Yes i have.
I saw that one on here but it doesn't seem to merge multiple letters, it
just does the first one on the list

David
 
Hi David

It's really all there in Albert's example. The steps are as follows:

1. Open a recordset that contains all the fields which might be required in
the mail merge.

2. Filter the recordset if necessary (e.g. "CustomerID=56" or
"WheelAlignmentDue<=Date()+7 and LetterSentDate<Date()-30")

3. Write the records to a delimited text file (Albert uses a comma-delimited
file, I prefer tabs. I also use API calls to create a file in the system
Temp folder)

4. Open your Word merge template document and set the data source to point
to your text file.

5. Do the merge.

Note that many mail merge examples have Word getting its data directly from
the Access database, but this is not a good idea for several reasons.
Albert outlines most of them here:
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html
Also, it can be a real pain filtering the required records.
 
David said:
Yes i have.
I saw that one on here but it doesn't seem to merge multiple letters, it
just does the first one on the list
Click to expand...

Take a look at the sample, and code behind the button that says

merge all records.

The code behind that button is

MergeAllWord ("select * from tblCustomers where city = 'Edmonton' ")

The above would send all customers from the city of Edmonton to the
merge....
 
Back
Top