mail merge issue

[small town newsletter]

just got a new computer with 2007. Old system was 2003 on Vista
Do invoices and envelopes for the advertisers in our town newsletter thru
mail merge which is an .mdb file in Access. Somehow, it has decided that I
can only use 3 of the 86 entries in that file. Am able to get to the whole
thing in Access by overriding the security popup but can't get it useable by
other programmes. Pulling my hair out. What can I do to get "access" to
this information short of retyping it all over again? Can't figure how to
print it from Access either which would make it somewhat easier. Am I stupid
or what? Access says it is giving me one-time use when I go into the options
but it still won't carry over to Publisher. Or Word. Cripes.

 

[Mary Sauer]

There is some help here:
Troubleshoot mail merge in Publisher
http://office.microsoft.com/en-us/publisher/HP030662451033.aspx

 

[small town newsletter]

Thanks Mary. Nothing particularly helpful in there. I somehow created a
duplicate database list when the new operating system was installed. Finally
figured out that the original one was in a different "documents" folder.
Deleted the new one and the old one links up for printing. Can't reach it
from Publisher directly to ammend it but can get at it thru Access.
Publisher will let me type a new list and can probably combine the two but
anyhow can work with this. Whew.

 

[Mary Sauer]

I'm glad it worked out for you. Publisher lists are Access data bases. You will
be able to combine the two.
If you want to edit the data in Publisher, open the Mail Merge Recipients,
high-light the data source, the edit box becomes active.