Mail merge ate my stored queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy Blankenship - 26 Feb 2006 20:01 GMT

I ran a mail merge from my Access database, and the next time I opened the
database the only query still stored there was the one that was used for the
mail merge. I was initially pleased with the seamless integration, but this
sucks! luckily I had a backup, but if anyone can say how to prevent this in
the future, I'm all ears!

Thanks;

Amy

Reply to this Message

Doug Robbins - Word MVP - 26 Feb 2006 21:58 GMT

Just how did you run the mail merge?

Using the user interface, I would be extremely surprised if anything like
you suggest would happen.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I ran a mail merge from my Access database, and the next time I opened the
>database the only query still stored there was the one that was used for
[quoted text clipped - 5 lines]
>
> Amy

Reply to this Message

Amy Blankenship - 27 Feb 2006 01:19 GMT

I went though the wizard from Access. Then Outlook wasn't my default
client, so I changed that and reopened the merge document in Word and
resent. I'm not sure which of these merges caused the problem.

Believe me, I was extremely surprised, too!

> Just how did you run the mail merge?
>
[quoted text clipped - 10 lines]
>>
>> Amy

Reply to this Message

Doug Robbins - Word MVP - 27 Feb 2006 04:52 GMT

When you say "stored queries", do you mean queries that you had saved in
Access? Or were they queries that you had defined, but not saved. If the
latter, I can imagine that when you interrupted the process, you may have
exited from Access and so the "not saved" queries may have been lost. I
cannot imagine any saved queries being lost however by this process.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I went though the wizard from Access. Then Outlook wasn't my default
>client, so I changed that and reopened the merge document in Word and
[quoted text clipped - 16 lines]
>>>
>>> Amy

Reply to this Message

Amy Blankenship - 27 Feb 2006 13:02 GMT

> When you say "stored queries", do you mean queries that you had saved in
> Access? Or were they queries that you had defined, but not saved. If the
> latter, I can imagine that when you interrupted the process, you may have
> exited from Access and so the "not saved" queries may have been lost. I
> cannot imagine any saved queries being lost however by this process.

They were stored in there, for use with the web page I was sending out the
e.mail for. I couldn't imagine it either, which is why I posted this
question. I even checked to see if somehow they'd become hidden objects,
but I always have my system set up to show hidden objects.

I'm guessing you've already provided the extent of the help that's available

Thanks anyway;

Amy

Reply to this Message