A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Mailmerge Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Dynamic Subject Line Email Merge by MHutcheson
I have a Word 2010 document linked to an Access 2010 data source. When a user clicks a button in Access, the Word document loads and performs a email merge using the below VBA code: Private Sub Document_Open() With ActiveDocument.MailMerge .Destination = wdSendToEmail .SuppressBlankLines =...
October 7th 13 04:05 PM
by MHutcheson Go to last post
0 3,630
email directory by nadja
Hi, I've created a mail merge (directory) which I would now like to send by email. The merge works perfectly fine as I'm able to finish the merge to individual pages or print. But when I click on "Send E-Mail messages" I get the error message "You cannot send catalog created by merging documents...
September 11th 13 01:43 PM
by nadja Go to last post
1 2,229
LINKing image using a conditional parameter by Bold Creature
!!!SOLVED!!! Hi, I need to merge three images (coloured circles) into a file, depening on a status in the data: - red circle if value is RED - amber circle if value is AMBER - green circle if value is GREEN I found how INCLUDEPICTURE allows me to insert images in Word, but how do I use the IF......
September 4th 13 09:17 AM
by Bold Creature Go to last post
0 1,716
2 Labels per record by PuffBunny
Hi (First post - please be kind) I am trying to create a series of mail merge labels for my movie database (in excel) and want to create two labels per movie - one to go on each side of the DVD sleeve. Label one is to include general data - such as Title, Genre, Cove image etc Label two is to...
August 27th 13 10:54 AM
by Ursul Go to last post
1 1,761
Red face
E-Mail Merge to Multiple Recipients by Vega10
I could use some help. I am trying to complete a mail merge via email and I would like to send the email to more than one person. For instance I am sending an email to the employee but I want to include the manager on the same email message. Is this possible? If so, how can I do this? I have tried...
August 22nd 13 11:16 AM
by Ursul Go to last post
1 2,047
Custom Subject Line from Excel Data by Kiran
Hi, I need to use mail merge to send multiple e-mails to different individuals for which subject line needs to be pulled from a excel column.My excel file name is sample.xlsx. The data in the sheet is as below, the issue column would be the source for subject.Request assistance in getting this...
August 22nd 13 01:38 AM
by KiwiRyu Go to last post
2 7,209
Conditional Formatting of background and text by KevinMoses
Greetings all I have created a mail merge document from a spreadsheet. One of the merge fields captures Residual Risk Ratings. I am trying to create an IF statement in order to use the following conditional formatting: Extreme (Pink shading, white text) High (Red shading, white text) Medium...
August 21st 13 01:56 AM
by K R Go to last post
2 8,008
Round Down Merge field by Niall
Hi I have got the following field in a mail merge document: {={MERGEFIELD Annual_Rent}/4} I am trying to round down the result to 2 decimal places and tried: {=ROUNDDOWN({MERGEFIELD Annual_Rent}/4,2)}
August 19th 13 09:05 PM
by 4zelka4 Go to last post
2 4,440
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF by Adi.Master
Hi.. I am new to this forum and have one question thats been bugging me since a month... hope to get a satisfying solution... I have a template which inputs data from an excel sheet.... I have entered the IF formula as follows: {IF {MERGEFIELD State} = "A" "My Paragraph 1" "{IF {MERGEFIELD...
August 18th 13 11:34 PM
by Adi.Master Go to last post
0 1,802
Multiplying a mail merge formula by Grazza215
Hi guys, Really hoping someone can help I've been trying to get this to work, but seem to be missing a trick. I am using a series of mergefields (linked to a CSV data sheet) and have this working fine: £ { = { mergefield "debits_H"} - { mergefield "EXPCT_AMT2"\#,0.00 } + { mergefield...
August 13th 13 04:42 PM
by Grazza215 Go to last post
0 2,667
Insert variables into mailmerge documents by Force
I have the following code that I am attempting to print labels with. The code to identify an individual will be the same for all labels. What I am using the mailmerge for is to cycle through the various labels that we are creating. I am trying to print out the variable finalOut with a CFLR at the...
August 5th 13 06:00 AM
by Force Go to last post
0 1,714
Getting a sentenced inserted into a letter. by Greg D Isringhaus
I am needing to know how to make a rule that has 3 different variables. I need a rule to enter just one sentence. Basically need a formula that reads: If "Exception" = "Y" and "Disease" = "Y" and "Age" = "Y" then "paragraph to be inserted." I just can't figure this out, I'm sure that it is...
July 23rd 13 05:52 PM
by Greg D Isringhaus Go to last post
0 1,672
Blank Line with If...then...else field by jmh117
Hello, I'm trying to create a document that will have one address block when the field Agent in my source document is "self" and two address blocks when Agent is not self. Currently I have the following code for the full address (not using the address block function as I have two addresses in...
July 3rd 13 03:01 AM
by jmh117 Go to last post
0 2,057
Mail Merge Makes One Page of One Name of One Label Instead by Little23
I am trying to do a mail merge for address labels using Office Depot white address labels that are the same size as Avery 5160. When I put in the Merge Fields, I then go to the Finish Merge and select Edit Individual Documents and then select all. Instead of using each label section for the list of...
May 30th 13 04:43 PM
by Little23 Go to last post
0 1,805
how do i print place cards by vicki
I am printing place cards for wedding shower - do I use mail merge or can and how do I access the template that I downloaded from place card site?
May 28th 13 04:43 PM
by IsaacLindsey Go to last post
2 6,359
Red face
Mail Merge Functionality by Doga
I am getting below error when i click on the Mail Merge button in code -- Method 'Run' of Object '_Application' Fail amd it is asking for the password code is as below Private Sub MergeMailDoc(as_Path As String, as_DocName As String, as_Where As String) Dim ls_DbConnection As String Dim...
May 22nd 13 07:28 AM
by Doga Go to last post
0 1,572
save merged document from c# without opening word by tom
Hi, I would like to save a merged document to disk, without opening word. The merging works fine if I make word visible and let the user save the doc, but if I try to save from code without showing word, i get 'Opening this document will run the following SQL command'. The code I use is as...
May 21st 13 03:06 AM
by talerKK Go to last post
6 6,457
excel - word - outlook -2007 mail merge problem by andy4u
Hi guys , I have got email id's in excel sheet ... i am trying to merge it with word 2007 and send email through outlook 2007 Now what happens lets say i have 2000 email id when i start sending/uploading mails in outlook after some email id , Emails stop uploading in outlook outbox and word...
May 17th 13 01:45 PM
by andy4u Go to last post
0 1,697
Conditonal Mail Merge statements by Admin Asst Extraordinaire
Hello! I am trying to use Mail Merge to make customer lists for various contractors. I need to know how I can make the list on a single page for one contractor, then start a new page for the next contractor. For example: Say ABC company has 4 customers in the list, I want them all on the same...
March 27th 13 08:38 PM
by Admin Asst Extraordinaire Go to last post
0 1,769
Saving Filter Parameters by Alajane
I have to merge Access and Word files often. The Access file Iím using has a lot of fields and I quite often need to merge different documents using the same filters. Iím currently merging about 20 documents that will all need the same six filtersóit takes quite a while to scroll down to...
March 19th 13 08:52 PM
by Alajane Go to last post
0 1,551
Post New Thread

Display Options
Showing threads 101 to 120 of 12041
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.