A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

e-Mail merge from Access database?



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2010, 10:57 PM posted to microsoft.public.outlook.contacts
dclaxon
external usenet poster
 
Posts: 3
Default e-Mail merge from Access database?

I have a database of club members in an access database and I would like to
send an e-mail to the ones who have an e-mail address. (Query for e-mail
field not null) Is there a way to do this directly, in the manner of a
printed mail merge in Word, or must I import the list into the contacts? And
if I must do that is there a way to keep that list separate from the main
contacts folder?

Thanks,
Dave
  #2  
Old March 10th, 2010, 11:59 PM posted to microsoft.public.outlook.contacts
Russ Valentine
external usenet poster
 
Posts: 1,155
Default e-Mail merge from Access database?

Not an Outlook question. Word can easily use an Access database as the
datasource for a merge to electronic mail.
--
Russ Valentine
"dclaxon" wrote in message
...
I have a database of club members in an access database and I would like to
send an e-mail to the ones who have an e-mail address. (Query for e-mail
field not null) Is there a way to do this directly, in the manner of a
printed mail merge in Word, or must I import the list into the contacts?
And
if I must do that is there a way to keep that list separate from the main
contacts folder?

Thanks,
Dave


  #3  
Old March 11th, 2010, 03:29 AM posted to microsoft.public.outlook.contacts
dclaxon
external usenet poster
 
Posts: 3
Default e-Mail merge from Access database?

Russ,

Thanks for the tip, I just figured it out myself a few minutes ago. I have
done mail merges with Word and Access many times before, I just hadn't
realized Word would also do e-mail.

Thanks,
Dave

"Russ Valentine" wrote:

Not an Outlook question. Word can easily use an Access database as the
datasource for a merge to electronic mail.
--
Russ Valentine
"dclaxon" wrote in message
...
I have a database of club members in an access database and I would like to
send an e-mail to the ones who have an e-mail address. (Query for e-mail
field not null) Is there a way to do this directly, in the manner of a
printed mail merge in Word, or must I import the list into the contacts?
And
if I must do that is there a way to keep that list separate from the main
contacts folder?

Thanks,
Dave


.

  #4  
Old March 11th, 2010, 04:23 AM posted to microsoft.public.outlook.contacts
Russ Valentine
external usenet poster
 
Posts: 1,155
Default e-Mail merge from Access database?

Word will invoke Outlook for the transport, but does not have to use it for
the data source.
--
Russ Valentine
"dclaxon" wrote in message
...
Russ,

Thanks for the tip, I just figured it out myself a few minutes ago. I have
done mail merges with Word and Access many times before, I just hadn't
realized Word would also do e-mail.

Thanks,
Dave

"Russ Valentine" wrote:

Not an Outlook question. Word can easily use an Access database as the
datasource for a merge to electronic mail.
--
Russ Valentine
"dclaxon" wrote in message
...
I have a database of club members in an access database and I would like
to
send an e-mail to the ones who have an e-mail address. (Query for
e-mail
field not null) Is there a way to do this directly, in the manner of a
printed mail merge in Word, or must I import the list into the
contacts?
And
if I must do that is there a way to keep that list separate from the
main
contacts folder?

Thanks,
Dave


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.