Mail Merge BIG problems - more

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

Guest

Albert - your solution is BRILLIANT - but I have three problems still

1. When I mail merge from a field that is a look up column, it is merging the ID number and not the text - I have tried loads of solutions but to no avail

2. On one of my forms it will not work and comes up with the message "Run time error 438" Object doesnot support this property or method

3. How do I get the merge all button to work - I copied the code but this is not happy

Any chance of more assistance PLEASE from Albert or anyone. Many thanks in advance
 
Albert - your solution is BRILLIANT - but I have three problems still:

1. When I mail merge from a field that is a look up column, it is merging the ID number and not the text - I have tried loads of solutions but to no avail.
Click to expand...

That's because THAT IS WHAT THE TABLE CONTAINS. That simple fact is
concealed from your view by the misdesigned, misleading, and obnoxious
Lookup misfeature; this is one of the many disadvantages of Lookup
fields. Use a Query joining your main table to the lookup table
instead.
2. On one of my forms it will not work and comes up with the message "Run time error 438" Object doesnot support this property or method.

3. How do I get the merge all button to work - I copied the code but this is not happy?
Click to expand...

Please post the code.
 
Back
Top