Queries and Mail Merge

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive

Try this link:

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

to Albert Kallal's "Super Easy Word Merge".

I should do exactly what you are needing.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive

How to I put it into my database?

Thanks

"Mr B" wrote:

Try this link:

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

to Albert Kallal's "Super Easy Word Merge".

I should do exactly what you are needing.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive

Check out Albert's explanations of how to use his solution at:

http://www.members.shaw.ca/AlbertKal...rge/page2.html

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

How to I put it into my database?

Thanks

"Mr B" wrote:

Try this link:

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

to Albert Kallal's "Super Easy Word Merge".

I should do exactly what you are needing.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive

Well I tried the steps and it does not work. By this I mean none of the
buttons work.

Thanks

"Mr B" wrote:

Check out Albert's explanations of how to use his solution at:

http://www.members.shaw.ca/AlbertKal...rge/page2.html

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

How to I put it into my database?

Thanks

"Mr B" wrote:

Try this link:

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

to Albert Kallal's "Super Easy Word Merge".

I should do exactly what you are needing.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive

I assume that you downloaded the file from Albert's site and that you were
successful in importing the necessary opjects as outlined by Albert's
documentation.

If you did all the things as he lays out for you to do, then place the
correct code on the Click event of your button, it should work.

Try to post specific issues and perhaps someone will be able to answer your
questions.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Well I tried the steps and it does not work. By this I mean none of the
buttons work.

Thanks

"Mr B" wrote:

Check out Albert's explanations of how to use his solution at:

http://www.members.shaw.ca/AlbertKal...rge/page2.html

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

How to I put it into my database?

Thanks

"Mr B" wrote:

Try this link:

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

to Albert Kallal's "Super Easy Word Merge".

I should do exactly what you are needing.

--
HTH

Mr B
askdoctoraccess dot com


"TheCaptain" wrote:

Hey,

For my database (Access 2007) I have a query that shows the results in a
form. Is there a way to send the query results to Word? I have tried
messing around with Mail Merge but I have not been able to have any success.
The reason I need to send results to Word (instead of using a report in
Access) is that I have a template that the end users can copy and paste into
their reports. They also need to be able to change formatting on the
template (color, cell size, etc...). NOTE: There are pictures that need to
be sent to the template as well (this is where I ran into trouble).

Thanks

And please be descriptive