Emailing with Access and Mail Merge

%3CLINGO-SUB%20id%3D%22lingo-sub-2150665%22%20slang%3D%22en-US%22%3EEmailing%20with%20Access%20and%20Mail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150665%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20new%20user%20of%20Access%20365.%26nbsp%3B%20I%20have%20created%20a%20personalized%20letter%20to%20send%20to%20multiple%20email%20recipients%20in%20an%20Access%20database.%26nbsp%3B%20I%20complete%20all%20the%20steps%2C%20but%20after%20clicking%20the%20OK%20in%20the%20last%20step%2C%20nothing%20happens.%26nbsp%3B%20I%20don't%20know%20if%20my%20email%20is%20connected%20to%20Access.%26nbsp%3B%20Does%20it%20need%20to%20be%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150665%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2150788%22%20slang%3D%22en-US%22%3ERe%3A%20Emailing%20with%20Access%20and%20Mail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459380%22%20target%3D%22_blank%22%3E%40Daniel_Pineault%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20and%20not%20very%20savy%20but%20I%20will%20try%20to%20explain.%20I%20appreciate%20any%20help%20you%20can%20give%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20steps%20I%20followed.%20I%20opened%20the%20database%20and%20selected%20the%20appropriate%20query.%20I%20opened%20External%20Data%20and%20Word%20Merge.%26nbsp%3B%20I%20selected%20Create%20a%20new%20document%20and%20link%20data%20to%20it.%20I%20selected%20email%20message%20as%20the%20document%20type.%20I%20selected%20Use%20current%20document%2C%20then%20Select%20Recipients%2C%20then%20Use%20existing%20list.%26nbsp%3B%20I%20then%20wrote%20the%20letter%20in%20Word%20and%20copied%20it%20into%20the%20window%20that%20opened%20in%20Access%20and%20selected%20%E2%80%9CMore%20Items%E2%80%9D%20to%20add%20the%20names%20and%20addresses.%20I%20then%20clicked%20to%20Preview%20the%20letter%2C%20then%20selected%20Complete%20your%20Merge.%26nbsp%3B%20Under%20that%20I%20clicked%20on%20Electronic%20Mail.%20I%20entered%20the%20message%20subject%20and%20selected%20HTML%20and%20Send%20Records%20to%20All.%26nbsp%3B%20When%20I%20clicked%20on%20OK%2C%20nothing%20happened.%26nbsp%3B%20No%20email%20was%20sent.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20background%20information%2C%20let%20me%20explain%20that%20someone%20else%20created%20the%20database%20which%20I%20transferred%20to%20my%20computer.%26nbsp%3B%20We%20both%20have%20access%20to%20the%20association%E2%80%99s%20email%20address.%26nbsp%3B%20But%20he%20has%20Microsoft%20Outlook%20as%20his%20email%20and%20I%20use%20AOL.%26nbsp%3B%20The%20shared%20email%20address%20is%20a%20gmail%20account.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don%E2%80%99t%20know%20if%20I%20have%20to%20have%20Outlook%20to%20use%20Access.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figured%20I%20must%20have%20to%20connect%20the%20Access%20database%20to%20my%20email.%26nbsp%3B%20But%2C%20if%20that%20is%20the%20case%2C%20I%20don%E2%80%99t%20know%20how%20to%20do%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20this%20answers%20your%20questions.%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECynthia%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2150728%22%20slang%3D%22en-US%22%3ERe%3A%20Emailing%20with%20Access%20and%20Mail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150728%22%20slang%3D%22en-US%22%3EIn%20which%20application%20did%20you%20create%20your%20letter%3F%3CBR%20%2F%3EHow%20exactly%20are%20you%20trying%20to%20send%20your%20email%3F%3CBR%20%2F%3EYou%20complete%20which%20steps%20exactly%3F%20Please%20give%20us%20a%20step%20by%20step%20explanation%20so%20we%20can%20follow%20along.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

I am a new user of Access 365.  I have created a personalized letter to send to multiple email recipients in an Access database.  I complete all the steps, but after clicking the OK in the last step, nothing happens.  I don't know if my email is connected to Access.  Does it need to be?  Thanks.

2 Replies
In which application did you create your letter?
How exactly are you trying to send your email?
You complete which steps exactly? Please give us a step by step explanation so we can follow along.

@Daniel_Pineault 

 

I am new and not very savy but I will try to explain. I appreciate any help you can give me. 

 

I am using Access.

 

Here are the steps I followed. I opened the database and selected the appropriate query. I opened External Data and Word Merge.  I selected Create a new document and link data to it. I selected email message as the document type. I selected Use current document, then Select Recipients, then Use existing list.  I then wrote the letter in Word and copied it into the window that opened in Access and selected “More Items” to add the names and addresses. I then clicked to Preview the letter, then selected Complete your Merge.  Under that I clicked on Electronic Mail. I entered the message subject and selected HTML and Send Records to All.  When I clicked on OK, nothing happened.  No email was sent.

 

As background information, let me explain that someone else created the database which I transferred to my computer.  We both have access to the association’s email address.  But he has Microsoft Outlook as his email and I use AOL.  The shared email address is a gmail account. 

 

I don’t know if I have to have Outlook to use Access. 

 

I figured I must have to connect the Access database to my email.  But, if that is the case, I don’t know how to do that.

 

Please let me know if this answers your questions. .

 

Cynthia