Home

Table will not export to email

%3CLINGO-SUB%20id%3D%22lingo-sub-783910%22%20slang%3D%22en-US%22%3ETable%20will%20not%20export%20to%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783910%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3BI%20am%20new%20to%20Access%20so%20please%20bear%20with%20me%20as%20I%20might%20sound%20redundant%20at%20times.%20I%20run%20a%20daily%20macro%20that%20runs%20queries%20to%20update%20the%20tables%20and%20then%20emails%20out%20the%20tables.%20We%20have%20received%20a%20computer%20update%20from%20the%20company%20and%20the%20next%20day%2C%20one%20file%20will%20not%20export%20to%20email.%20The%20macro%20works%20up%20until%20then%20and%20I%20must%20hit%20Esc%20after%20I%20send%20the%20first%20email%20to%20skip%20the%20problematic%20one%20or%20else%20I%20get%20error%203270%20(The%20emails%20after%20send%20fine%20if%20i%20skip%20over%20the%20problematic%20table).%20Here%20is%20what%20I%20know%20that%20might%20be%20of%20some%20use%3A%3C%2FP%3E%3CP%3E1.%20Nothing%20has%20changed%20in%20the%20environment%20except%20for%20the%20update%3C%2FP%3E%3CP%3E2.%20I%20can%20manually%20export%20the%20table%20to%20excel%20and%20attach%2Fsend%20that%20file%3C%2FP%3E%3CP%3E3.%20I%20can%20not%20export%20straight%20into%20an%20email.%3C%2FP%3E%3CP%3E4.%20This%20table%20is%20main%20source%20of%20data%20and%20is%20linked%20to%20the%20other%20tables%3C%2FP%3E%3CP%3E5.%20The%20query%20filling%20this%20table%20is%20the%20only%20query%20linked%20to%20an%20excel%20file%20.(xls%20updated%20daily)%20stored%20in%20our%20share%20drive.%20(all%20queries%20also%20pull%20from%20our%20ERP%20system)%3C%2FP%3E%3CP%3E6.%20The%20query%20runs%20fine%20without%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20thinking%20it%20might%20be%20a%20security%20thing%20but%20I%20am%20not%20sure.%20Any%20advice%20would%20be%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-783910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783922%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20will%20not%20export%20to%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783922%22%20slang%3D%22en-US%22%3E%3CP%3EUpdate%3A%20As%20I%20am%20playing%20around%20I%20stumbled%20upon%20the%20solution.%20(I%20think)%20The%20excel%20file%20has%20been%20exported%20to%20email%20as%20.xls%20just%20like%20all%20the%20others.%20I%20am%20able%20to%20export%20to%20excel%20as%20.xls%20and%20send%20that%20file%20but%20if%20I%20export%20to%20email%20an%20.xlsx%2C%20it%20works%20just%20fine!%20I%20hope%20I%20am%20able%20to%20help%20someone%20and%20if%20anyone%20can%20help%20with%20the%20%22Why%22%20that%20would%20be%20great!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Cameron218
New Contributor

Hi Everyone,

 I am new to Access so please bear with me as I might sound redundant at times. I run a daily macro that runs queries to update the tables and then emails out the tables. We have received a computer update from the company and the next day, one file will not export to email. The macro works up until then and I must hit Esc after I send the first email to skip the problematic one or else I get error 3270 (The emails after send fine if i skip over the problematic table). Here is what I know that might be of some use:

1. Nothing has changed in the environment except for the update

2. I can manually export the table to excel and attach/send that file

3. I can not export straight into an email.

4. This table is main source of data and is linked to the other tables

5. The query filling this table is the only query linked to an excel file .(xls updated daily) stored in our share drive. (all queries also pull from our ERP system)

6. The query runs fine without error.

 

I'm thinking it might be a security thing but I am not sure. Any advice would be much appreciated!

1 Reply
Highlighted

Update: As I am playing around I stumbled upon the solution. (I think) The excel file has been exported to email as .xls just like all the others. I am able to export to excel as .xls and send that file but if I export to email an .xlsx, it works just fine! I hope I am able to help someone and if anyone can help with the "Why" that would be great!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies