Using mail merge with stationery

Status
Not open for further replies.

mimo

Member
Outlook version
Email Account
Exchange Server
I am using the Mail Merge function in MS Outlook to send emails to selected contacts but the emails do not use the stationery I have selected in Tools/Options/Mail Format. The reason I need the stationery to be included is because I have converted our monthly newsletter into a 'stationery' so that it appears on recipients' screens when they open the email without them having to double click on an attachment. Can anyone help?

Mimo
 

larry

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Try creating the stationary as a word document then use it as the document source. I don't know if it will work, I'm a guy, basic white looks good to me so I have not tried it. LOL I know you can't mail merge attachments, you need to use a 3rd party utility. I also know attachments turn into images if you try to do it in word, so I know mail merge can send images. For this reason, I think merging to a document designed like the stationery will work.

Otherwise, the other option is use the BCC field and send the message to the masses, use a 3rd party bulk mailer program, or try one of the mail merge ultlities.

Mass Mail Tools for Outlook | Slipstick Systems
 

mimo

Member
Outlook version
Email Account
Exchange Server
Try creating the stationary as a word document then use it as the document source. I don't know if it will work, I'm a guy, basic white looks good to me so I have not tried it. LOL I know you can't mail merge attachments, you need to use a 3rd party utility. I also know attachments turn into images if you try to do it in word, so I know mail merge can send images. For this reason, I think merging to a document designed like the stationery will work.

Otherwise, the other option is use the BCC field and send the message to the masses, use a 3rd party bulk mailer program, or try one of the mail merge ultlities.

Mass Mail Tools for Outlook | Slipstick Systems

Thanks for your thoughts Larry. I too am completely satisfied with white (!) but am not concerned with the background colour - I have a nine-page document, perfectly formatted with links to previous month's newsletters all set up as 'stationery' which I would struggle to replicate in MS Word. It has graphs and tables etc., so at the moment I simply click on 'new message' and the cursor is sitting at the top of this nine-page document ready for me to write a few sentences as a cover note before I press 'send'. I want to use Mail Merge so I can send the same covering message with this document to a few hundred people, but Mail Merge cancels the Stationery you have chosen. Might there be a solution in VBA?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Since mail merge does not work in Outlook directly (you need to work in Word and send to Outlook), I would try one of the utilities at the link larry posted. The only other option is to use the BCC field and insert all addresses.

How badly does it get screwed up If you save as HTML and open in Word, or select all and paste into word?

Hyperlinks used to be broken during mail merges - not sure if that is still the case, so its possible doing it in word won't work anyway. Test it before tweaking the pages.

It is possible to use VBA to send a message created from a template but I don't have code that would read an address list - the utilities are affordable, with a good ROI unless you are a good VBA coder and can whip something out in an hour or two.
 

mimo

Member
Outlook version
Email Account
Exchange Server
Since mail merge does not work in Outlook directly (you need to work in Word and send to Outlook), I would try one of the utilities at the link larry posted. The only other option is to use the BCC field and insert all addresses.

How badly does it get screwed up If you save as HTML and open in Word, or select all and paste into word?

Hyperlinks used to be broken during mail merges - not sure if that is still the case, so its possible doing it in word won't work anyway. Test it before tweaking the pages.

It is possible to use VBA to send a message created from a template but I don't have code that would read an address list - the utilities are affordable, with a good ROI unless you are a good VBA coder and can whip something out in an hour or two.

Thanks Diane. I will try to arrange it in HTML in MS Word - having just asked my design team to prepare it as stationery I'm hesitating before going straight back to them to ask them now to prepare it in Word, especially as they have told me it is not as simple as it sounds due to the repagination Word insists on doing (as stationery it flows well in email HTML format) - but as regards the utilities you suggest, it does seem strange that one would have to buy an additional programme when everything I want is available in Outlook and Word. I just need it to stop suppressing my choice of stationery!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It has to do with the way outside programs call up Outlook - it's after the stationery would be added.

Before the design team does anything, you need to test it and make sure the urls work. If they don't, you'll need to use a a utility or bulk mail program.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A Reply/Forward Emails using Mail Merge BCM (Business Contact Manager) 0
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
O Using .OST and .PST mail thru different providers Using Outlook 5
Frédéric Save E mail using different path. Outlook VBA and Custom Forms 24
R Unable to send mail using Cox.net Using Outlook 1
A Can i apply mail rules to inbox sub folders using VBA Outlook VBA and Custom Forms 2
reza Macro to automatic reply using orignal mail Outlook VBA and Custom Forms 10
V Using custom field data in mail body + mailto hyperlink Outlook VBA and Custom Forms 7
J Outlook 2013 and outlook.com issues when using mail alias Using Outlook.com accounts in Outlook 2
A Creating rule to create week folder and transfer mail using alert Using Outlook 3
A Outlook 2013 IMAP using Google Mail App not syching Sent Mail Using Outlook 3
K How to make use of outlook calendar, contacts & tasks using personal POP3 mail Using Outlook 1
F Using Outlook 2007 as an IMAP Mail Station Without Saving Data Locally Using Outlook 2
D How do I mail-enable a Public Folder Sub-folder in exchnage 2007 using shell ? Exchange Server Administration 0
A Outlook VBA - moving mail item to public folder using variable within path Using Outlook 6
P Using Outlook to view Office 365 e-Mail Using Outlook 1
J Sending Mail From A Different Address Using Outlook 2011 for Mac Using Outlook 0
N Sending encrypted signed mail using outlook 2010 Using Outlook 1
L How can I delete stationery from Actions, New Mail Message Using in outlook 2007? Using Outlook 6
H using macro for sending multiple mail in outlook Outlook VBA and Custom Forms 1
J Using Access to obtain E-mail address Outlook VBA and Custom Forms 5
J Adding a background image to a mail item using automation Outlook VBA and Custom Forms 2
X Highlight block of text in an outlook mail using c#2008 vsto Outlook VBA and Custom Forms 1
H attaching e-mails to new e-mail using VBA Outlook VBA and Custom Forms 1
S Using Outlook on both desktop and laptop for one e-mail BCM (Business Contact Manager) 2
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
M USING INITIALS AS RECIPIENTS Using Outlook 1
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
M Saving emails using Visual Basic - Selecting folder with msoFileDialogFolderPicker Outlook VBA and Custom Forms 6
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M Extract "Date sent" from emails (saved to folder using drag and drop) Outlook VBA and Custom Forms 1
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1
H Stationery using between OL 2019 and OL 2010 Using Outlook 0
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 4
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10

Similar threads

Top