Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

MS Access Reports


  • Please log in to reply

#1
swicklund

swicklund

    Member

  • Member
  • PipPip
  • 25 posts
I have a several buttons set up on a form that will automatically set up various reports to be mailed in a .snp format using the command:

DoCmd.SendObject acReport, stDocName, acFormatSNP

What I would like to do, is send multiple reports w/ one email. When I try putting this command multiple times in the code for a button, then it sets up the emails, one after the other.
Any thoughts??? :whistling:
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
http://www.utteracce...amp;type=thread <---this article seems to suggest that you cannot do this with the sendobject function...it has a few options for other methods
  • 0

#3
lurky

lurky

    Member

  • Member
  • PipPipPip
  • 113 posts
Swicklund, I'm not really sure what kind of environment you're using or the actual platform involved. But you might try to work something out with the MS Word mail merge feature. I'm pretty terrible with code, so I'm not even sure you could automate it.

Also, do you have a sharepoint server available? You put the database on the sharepoint server and set it up as a data source for an infopath form, which I know you could automate. You're obviously far, far over my head in terms of writing code so I don't really have anything to help you out with in terms of actually automating it. Just kindof tossing in some logistics in case you hadn't thought of them.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP