Where to from here if no-one answered a question? Please help!

K

kneedeep

I asked the following question two days ago and received no replies... and
now I am completely stuck and don't know who to ask next... any suggestions?
Is there a way to ask Microsoft themselves? If so, where?

This is my question:
From a Microsoft Access form I want to send emails to different email
addresses (selected from a list in the Access form) and attach to the email
different Word documents (also selected from a list in the Access form).

Is this possible? If so, where do I start?
 
R

Rick Brandt

kneedeep said:
I asked the following question two days ago and received no
replies... and now I am completely stuck and don't know who to ask
next... any suggestions? Is there a way to ask Microsoft themselves?
If so, where?

This is my question:
From a Microsoft Access form I want to send emails to different email
addresses (selected from a list in the Access form) and attach to the
email different Word documents (also selected from a list in the
Access form).

Is this possible? If so, where do I start?
Click to expand...

Code at link below handles the Email with Word attachment.

http://www.mvps.org/access/modules/mdl0019.htm
 
V

Van T. Dinh

Sure. You can ask Microsoft. It is called "Paid Support". You pay first
and then ask the question. If you are a big account, Microsoft may provide
the service on credit.

To do it on your own with a bit of help:

1. Have you tried Arvin Meyer's samples "EmailSenate" & "EmailSenate2K"?

See http://www.datastrat.com/DataStrat2.htm

2. Search Microsoft Support Web site

http://support.microsoft.com/

Microsoft calls this "Self-support option".
 
A

Albert D.Kallal

This is my question:
From a Microsoft Access form I want to send emails to different email
addresses (selected from a list in the Access form) and attach to the
email
different Word documents (also selected from a list in the Access form).

Is this possible? If so, where do I start?
Click to expand...

The above is possible, but you don't mention what you tried so far. Further,
your solution can wind up taking a good amount of code, and worse, that code
can be quite difficult to write. Since you have not mentioned what you
tired, and what skills level you have, offering a solution is quite hard. My
bets are that your question was likely not answered, since the solution you
ask for requites a lot of work (certainly more then what can be answered in
a newsgroup).

If your coding skills are strong, then you will need to read up on the
outlook object model, and the word object model (both are documented in the
respective applications VBA help). You also don't explain, or mention what
email application you use. You can automate outlook, but not outlook
express.

You have got a few links in the other posts that give you some ideas. If
rolling your own software proves to be too difficult, then perhaps you
should just enlist the services a professional developer. Even better is to
find one in your local market, as that means you can build a good working
relationship. The yellow pages even for small cities tends to have 100's of
pages of hungry software and consultants looking for work.

There is also some great links for outlook, and email stuff here:

http://www.slipstick.com/addins/mail.htm
 
D

Dirk Goldgar

kneedeep said:
I asked the following question two days ago and received no
replies... and now I am completely stuck and don't know who to ask
next... any suggestions? Is there a way to ask Microsoft themselves?
If so, where?

This is my question:
From a Microsoft Access form I want to send emails to different email
addresses (selected from a list in the Access form) and attach to the
email different Word documents (also selected from a list in the
Access form).

Is this possible? If so, where do I start?
Click to expand...

It's absolutely possible, but you need to take it a piece at a time if
you want people to commit their spare time to helping you.

Where is the list of e-mail addresses going to come from? A table, with
the EmailAddress field displayed in a list box on the form? Have you
got that part set up and working?

Where is the list of Word documents going to come from? A table? A
directory on your hard disk? Have you got a list box to display these
set up and working yet? If not, this could be a question in itself, and
you need to get it working before you go any farther.

Sending e-mails with Word attachments can involve a fair amount of
coding. If you're comfortable with it, you can look at various
alternatives described in Tony Toews' Access Email FAQ:
http://www.granite.ab.ca/access/email.htm .

Did you want to send a separate e-mail (with the attachments) to each
recipient, or did you want to send one e-mail to multiple receipients?
 
Top