Y
yipppeee
Hi everyone!
I'm trying to automate a process that sends a fixed-width, text file (a
query). If I use "sendobject", it formats it as a delimited text file which
is unacceptable. Currently it is set up as a two-step process - (1) export
to desktop using an export spec, and (2) email the text file. However this
is a manual process. I need this to run at midnightIsn't there a way using
Access or VBA to send a fixed-width text file?
While I'm asking, is there a way to get around the warning message that
Access asks when using "sendobject "? Can a "YES" answer be automated?
This process needs to be run each Monday evening & I really don't want to
have to stay late every Monday.
TIA
(e-mail address removed)
I'm trying to automate a process that sends a fixed-width, text file (a
query). If I use "sendobject", it formats it as a delimited text file which
is unacceptable. Currently it is set up as a two-step process - (1) export
to desktop using an export spec, and (2) email the text file. However this
is a manual process. I need this to run at midnightIsn't there a way using
Access or VBA to send a fixed-width text file?
While I'm asking, is there a way to get around the warning message that
Access asks when using "sendobject "? Can a "YES" answer be automated?
This process needs to be run each Monday evening & I really don't want to
have to stay late every Monday.
TIA
(e-mail address removed)