Solved

Access mailing list to Outlook for batch (list) send

Posted on 2002-06-16
7
183 Views
Last Modified: 2013-12-03
I hope this is a stupidly simple question. But it's necessary, because, as usual, Microsoft's docs tell you all about a process except how to do it.

I want to send a batch email (content*1; addresses*n) to Outlook, using a list of addresses created in Access 97. (Since this is a 1-time effort, it makes no difference if text is created in Access or in Outlook.)

I can do it for one addressee.  Is batching as simple as just creating one horrendous string of all the eaddresses, with commas in between?  Is there a length limit?

OR: What's the format of the "personal list" MS' documentation  talks about, and where does it go? Is it a  (by what) delimited list? or xml (what tags?)   Do names have to pre-exist in Outlook's phone book?  I'm hoping I can just create the address file (I don't need any other info there, so 1 column is fine),  tell Outlook to send to the filename and compose.  How DO I  tell  Outlook to send to "the filename"?

Are there any gotchas in the fact that this might be  created on a Win98 machine and sent from a Win2000 machine?

If it's not as simple as hoped, as for more points!

Thanks.

Marilyn Justman
0
Comment
Question by:mjustman
  • 2
  • 2
7 Comments
 
LVL 9

Expert Comment

by:ShaunWilde
ID: 7086573
if you can do it for one - why not just use a loop
0
 

Author Comment

by:mjustman
ID: 7090015
Shaun:
Good comment!  Now: Which loop?
The way I've got my code for 1 set up, the process would involve opening the Access Mail form (and possibly --but I don't know how Outlook works--Outlook) for each send, and having a real person "ok" each.   What I want to achieve is to use the power of Outlook to send 1 message to n addresses.

My own email client lets me create a one-column list of addresses in a file, and then put that FILENAME into the "to" slot, and voila --off the stuff goes.  (The replication happens at the smtp server; not before.) MS'  documentation suggests that you can do the equivalent with Outlook...but it involves setting up a Personal Directory (ok, I've done that) and .... here's the catch ... I think they want a specific file extension (and possibly unique format?) for the list, so that Outlook can see it.  If I'm right ... WHAT'S the EXTENSION? (and, if other than a 1 column list, what's the format?)

??

Thanks.

Marilyn
0
 
LVL 9

Expert Comment

by:ShaunWilde
ID: 7090300
hmm - do you have a list of addresses or can you enumerate them - sorry for being vague but I am not an Access developer but I have automated Outlook to access the emails so you'll have to fill in the gaps until someoe more knowledgeable starts to help
0
 

Author Comment

by:mjustman
ID: 7091663
Shaun:
It IS basically an Outlook question.
I have the list; I can have Access output it to a text file .. either delimited (with what character?) or  simply with a CR after each item.
I want to point Outlook at that file in the TO line  
TO:  Mytextfile[.txt?]
make up a message and send.

Thanks.

Marilyn
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10698050
Closed, 50 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (http://www.experts-exchange.com/A_2172.html), we saw how to put the Delete button back there where it belongs.  "Delete" is …
In this article, I will show how to use the Ribbon IDs Tool Window to assign the built-in Office icons to a ribbon button.  This tool will help us to find the OfficeImageId that corresponds to our desired built-in Office icon. The tool is part of…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now