Hi All,

Has anyone else had this issue............

In AccessXP I use a Docmd.OutputTo a spreadsheet and then I send that
created spreadsheet to a user as an attachment. When the user tries to
open the attachment they get "File Format is not Valid".

I did the process a second time and included me in the email and I can
open the attachment without issue. Any ideas why it does work for me
but not the other user??
bobh.

On Apr 26, 2:50*pm, bobh <vulca... (AT) yahoo (DOT) com> wrote:

I'm in deep trouble here and I'm looking for ideas as to what to look
at or reseach to figure out what the issue is as I now have three
users reporting the same problem. Excel by itself works on the users
pc

anyone know if Access 'advanced' wizards need to be installed to use
certain Access functions like OutputTO?
bobh.

bobh wrote:

http://support.microsoft.com/?kbid=327764

I looked for "Excel File Format is not Valid" in Google and found the above.

On Apr 27, 10:25*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:

thanks for the link I'll test that but I sure hope it's not a registry
issue as I surely could not get Corp IT to fix each registry on an
enterprise level.
bobh.

On Apr 27, 10:25*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
Found the issue, for anyone interested the company I work for is
changing email client software, from GroupWise to Outlook2007 which
meant I had to change all my Access applications I have throughout the
company. Each application has some form of email automation in it and
the vba code talked specifically to Groupwise. After about two months
of trying to work vba code to talk to Outlook I found Outlook not to
be very friendly when it comes to email automation from outside
itself. So, I went for a CDO solution which caused many arguments with
Corp IT about openning up a smtp port for email automation out of
Access but it finally got done.
After developing a 'simulated' email form in access, adding the vba
code and testing it I distributed it to all my apps. Two users of a
particular email automation process only have a Subject line, no
TextBody and my code checks each item for data and on the TextBody
item if there is no data I do not pass it along as in,
If Me!bxMess <> "" then
.TextBody = Me!bxMess
end if

This for some reason causes any attachment to get mucked up, after
changing my code to not check the bxMess and just pass the item along
empty or not as in,
.TextBody = Me!bxMess

the attachment is a mighty fine attachment............ strange but
true
bobh.