Who Reads These Things?

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

That is the question, the response to which may answer my
next question - why are some questions left in the dust?

I posted "email from form" by Bill on 7/7 at 10:23. I
watched anxiously as subsequent new questions were posted
and responded to. Mine still lays there unanswered.

This is not an indictment but an attempt to understand the
system. Is the question to hard, obscure or time demanding
to answer? Should I phrase things differently?

Thanks,

Bill
 
Bill said:
That is the question, the response to which may answer my
next question - why are some questions left in the dust?

I posted "email from form" by Bill on 7/7 at 10:23. I
watched anxiously as subsequent new questions were posted
and responded to. Mine still lays there unanswered.

This is not an indictment but an attempt to understand the
system. Is the question to hard, obscure or time demanding
to answer? Should I phrase things differently?
Click to expand...

It may not have reached all servers.
It may not be of interest to anybody.
The question may be to long and complex to answer without getting paid or
poorly worded.
It may have been asked and answered 10 times in the last three days.
Sometimes I get tired of answering questions that are trivial to answer or
easy to find the answer in help and for which MSFT has supplied many samples
with the included Northwind database.

Professionals read manuals and push F1 a lot..
 
Sometimes there may no be an immediate answer so you get passed over.... as
to your original question, you might look at the SendObject method in VBA.
That may work for you.

HTH
Damon
 
On Thu, 8 Jul 2004 08:48:47 -0700, "Bill"

Essentially all of the people answering questions are volunteers like
me. Even when Microsoft employees post answers, my understanding is
that they're doing it on their own time, in addition to their assigned
duties.
That is the question, the response to which may answer my
next question - why are some questions left in the dust?

I posted "email from form" by Bill on 7/7 at 10:23. I
watched anxiously as subsequent new questions were posted
and responded to. Mine still lays there unanswered.

This is not an indictment but an attempt to understand the
system. Is the question to hard, obscure or time demanding
to answer? Should I phrase things differently?
Click to expand...

I'll answer questions if:

- I have the time to do so
- The question is clearly stated, providing enough information to
understand the situation but not a deluge of extraneous detail
- I know the answer (or know how to find it relatively quickly)

I don't recall your previous post, but my guess is that I'd have
skipped it because I've never actually worked with emailing from
Access.

Do note that a) this service if free, and b) the MVP's and other
volunteers are just that: *volunteers*. We're not paid to answer
questions; and although we try hard, there may well be some that fall
through the cracks. Check out the posting hints at
http://www.mvps.org/access to see if your message is appropriately
phrased; and by all means search the archives, on the Microsoft
website or (for a complete multiyear history) at
http://groups.google.com - do an Advanced Search of the
microsoft.public.access.* newsgroups.

Good luck!
 
Bill said:
That is the question, the response to which may answer my
next question - why are some questions left in the dust?

I posted "email from form" by Bill on 7/7 at 10:23. I
watched anxiously as subsequent new questions were posted
and responded to. Mine still lays there unanswered.

This is not an indictment but an attempt to understand the
system. Is the question to hard, obscure or time demanding
to answer? Should I phrase things differently?

Thanks,

Bill
Click to expand...

No, your question was fine, but in fact is a difficult question. To answer
that email question, there is quite a few software disciplines and
technologies involved to answer your question. First, what kind of email
client are you using. Likely, you want to use a programmable email system
(since, how else can you automate this process). This likely means you have
to use, setup, and learn how outlook works. All of a sudden, we are talking
about programming and using Outlook. That is a big program, and can take a
lot of time to learn. (you can't use Outlook express, since it is not
programmable).

So, all of a sudden, we are now working with two pieces of complex software,
and a some good programming knowledge is needed for each system. And, some
readers looking at your request might also assume that we need ms-word
programming ability also. Now, we are up to 3 possible software packages,
and the required years of learning all 3 packages. So, what you ask is going
to take some fairly advanced knowlenage, and programming ability here.

So, no..your question is fine, but you just don't have enough knowledge to
realize how difficult your question is.

Here is one link with one possible solution:
http://www.mvps.org/access/modules/mdl0019.htm

And,. here is a code snip I found in this newsgroup by googling;
Option Explicit

Public Sub MessageToSend()
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
With objOutlookMsg
Set objOutlookRecip = .Recipients.Add
("(e-mail address removed)")
.Subject = "Quarterly Performance Information"
.Importance = olImportanceHigh
Set objOutlookAttach = .Attachments.Add("A:\Test.pdf")
.Body="Hello!"
.Send
End with
exitSub:
Set objOutlookMsg = Nothing
Set objOutlook = Nothing
Set objOutlookAttach = Nothing
Exit Sub
End Sub
Click to expand...

The above would let you attached a document, and send a email. You would
further have to code a loop to "process a query". As you can see, just about
all disciplines of programming are need. To accomplish this task you need:

Good VBA coding skills
You need to know how to write and code record set processing in VBA
(reocrdset processing, and process data in a loop)
You need to know how to write automaton code, and automate outlook (the
above access example does this)

The above is a good start.
 
This doesn't apply to your post but I am less likely to respond to a post that
starts out with "Hey There", "Hi Guys and Gals" or similar. I am also less
likely to respond to a post from some weird name. I am much more likely to
respond to posts where the poster signs his name like you did.

Just personal preferences!

Steve
PC Datasheet
 
Thanks,

That is a very good explanation.

The heart of the matter is, indeed, that I don't know
enough to realize how difficult is the question.

Bill
 
-----Original Message-----
That is the question, the response to which may answer my
next question - why are some questions left in the dust?

I posted "email from form" by Bill on 7/7 at 10:23. I
watched anxiously as subsequent new questions were posted
and responded to. Mine still lays there unanswered.

This is not an indictment but an attempt to understand the
system. Is the question to hard, obscure or time demanding
to answer? Should I phrase things differently?

Thanks,

Bill
.
I was please to get some good answers and to find that it
Click to expand...
was not poor submission on my part. I understand much
better now that the nature of the question was difficult
and took just the right person to answer.

Bill
 
Back
Top