Sending Serial Emails through Access

[RSteph]

I have a databe setup, with a form that allows a user to enter text for a
subject line and body of an e-mail, then use a query to generate a list of
e-mails to send to; it also allows for the user to browse to a file to attach
to the e-mail. The code then sends the email out as a serial email, bypassing
outlook.

If there is no attachment the e-mails go out just fine, but if I try to add
an attachment (in this case a .doc file) the attachment doesn't go out, and
instead it adds a large block of random characters to the bottom of my
e-mail. Some of the recipients are complaining that this is causing problems
on their end when trying to open the e-mails.

Does anyone have any ideas why adding the attachment is causing this
problem? This computer is using Office 2003 (Access, Word, Excel, Outlook).

Any help would be greatly appreciated.

Thank you.

 

[Daniel Pineault]

OK you state that you are bypassing Outlook. So what method have you adopted
instead? What is your code for sending the email and adding the attachment.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[ryguy7272]

Why do you want to bypass Outlook? Take a look at this file:
http://www.mediafire.com/download.php?yyynczvuqzt

You can download it from my space on a server I use.

HTH,
Ryan---

 

[Daniel Pineault]

ryguy7272,

FYI, your link does not work with IE.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

Why do you want to bypass Outlook? Take a look at this file:
http://www.mediafire.com/download.php?yyynczvuqzt

You can download it from my space on a server I use.

Why download that file when it's a copy of
http://support.microsoft.com/kb/318881

Indeed you are in violation of MS copyright.

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/