Solved

Access mailing list to Outlook for batch (list) send

Posted on 2002-06-16
7
188 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

717 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