Solved

Outlook 2010 mail merge through VPN

Posted on 2011-03-11
7
466 Views
Last Modified: 2013-11-05
I have a rather complicated question and I will try to make it understandable in English, which is not my native language.

I have a small company with an office and I also work from my home with a VPN connection to the Office Server running SBS 2003.

Up to now, I used Office 2003. For offers to customer and enquiries to suppliers, I have used Word dot files, linked to an Access 2003 database. Through Word 2003 I sent personalized e-mails with Outlook 2003 mail merge.
This worked in the office but also from my home through VPN. I simply opened the Word.dot file 9with the link to the database. With mail merge and Outlook I could send separate messages to either customers or suppliers.
I recently upgraded to Office 2010 on both locations and now this method is not working from my home anymore? I converted the Access database to the 2010 version. I also converted the Word.dot files to the Word.dotm files but I cannot send my messages anymore through Outlook 2010.
I have checked macro settings and other security setting because I assume it is related to security setting but I am not sure of course.
I use the Dutch language version of Outlook.
0
Comment
Question by:jrvd
[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
  • 4
7 Comments
 
LVL 5

Expert Comment

by:zazagor
ID: 35156016
Hi,

What kind of VPN? SSL VPN?
Try to add the ip of you VPN site/server to "Trusted Sites" in Internet Explorer.
Try using the Outlook OWA. Does that work?

//zaZagor
0
 

Author Comment

by:jrvd
ID: 35156255
Thanks for your reply. To be honest, I don't know what kind of VPN I have, just the standard VPN I guess. How can I see what kind of VPN I have?

I do not use Internet Explorer in this procedure so can it still make a difference if I add the IP to the trusted zone?

I have always assumed that Outlook OWA does not have all the functions I use for this and I must confess that I never actually tried it.

What I do is;

Open the VPN to the server in the office.
In file explorer, go the the Word.dot(x) file I need.
Open the dot(x) file so the link to the Access database is also activated (get some sql warnings but no big deal).
Now I have the Word file on the screen and through one the the tabs in Outlook I can select the recipients and send the e-mail with mail merge.
As said, I use the Dutch Outlook version so I don't know the English names of the functions and tabs I refer to.
0
 

Author Comment

by:jrvd
ID: 35165713
Tried Outlook OWA but that does not work but thanks anyway.
0
 

Author Comment

by:jrvd
ID: 35166620
When I use a plain text file, it takes a long time but the e-mail is sent. Meanwhile I assume it is ralated to Outlook 2010 not being the standard e-mail client.

I am running Windows 7 and I have put Windows Mail back from Vista to Windows 7 so perhaps this is causing the trouble I now have with Outlook 2010. I checked and Outlook 2010 is set as standard client. Just selected it again, just to be sure ;-).

In my other PC in the Office I have done the same thing with Windows Mail and there mailmerge works fine so perhaps I should re-install Office 2010 or remove Windows Mail. Maybe the sequence on my PC in the office was different but I can't remember that.
0
 

Accepted Solution

by:
jrvd earned 0 total points
ID: 35177437
I re-installed Office 2010 and the problem seems to be solved. I think it is caused by the work around to get Windows Mail back in Windows 7.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Changing a few Outlook Options can help keep you organized!
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 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