Hi I know how to use mail merge wizard but that only merges names and addresses. What Im trying to do is put other data in and it merges into a document. I.E with ref to your application no (no from mail merge data) I am writing Is there anyway i can do this?

Hello! I am trying to pull data from a source that has some duplicate entries (records) and I want to skip any records if a field value already appears in the previous records Data Source AC01 | Red | Blue | Green AC01 | Blue | Yellow - Red AC02 | Green | Blue | Green AC02 | Blue | Red | Green

In a mail merge, I need to create an index based on a Mergefield. When I try this, I get an index with every page listed and the MERGEFIED rather than the field contents which generated in the mail merge. Is there a way to create an index based on a mail merge field rather than static text? I have...

Very frustrated as can not make MERGEFIELDs work as every Help message I can find seems to indicate they should. I'm producing a directory but some people do not want their phone numbers or email info included, so in the directory, Excel DB, I included a field mask called "Hide" with the form...

I have been trying to figure this out with no positive outcome. Anyone with an idea or a solution, please share. P-Lab

Hi There, Really need some advice here after cracking my head and searching for a long time. I have a negative time displayed in my excel sheet (e.g -01:22 mm:ss) which I would like to retain the format when I do a mail merge on MS word. However, the time gets converted to 01:22. I have tried to...

Never had this big a struggle with if then, but then I've never introduced a second variable. This works fine and dandy: { IF { MERGEFIELD f3 } = "Y" "{ MERGEFIELD f18 }" "{ MERGEFIELD f2 } (If party is a child, insert this name, if not insert that name). It's when I go for two conditions to...

I want to share issues related to Samsung printer. Sometimes the issue may occur while printing important emails. Recover the issue with just one click, follow this quick fix guide samsung printer error code u1-2320. I had personally checked and had applied the steps to recover Samsung printer and...

Hi In my excel-sheet (source document) I have a column with ssnr in looking like "########-####" and some with "########-T###". The format in the column in excel is Custom "########-####". How can I merge this numbers in to my word document? Right now I have "{MERGEFIELD ssnr \#...

I have been trying to create some labels and some of my fields are empty. The fields that may be empty a Address_2 ; Address_3 ; Address_4 and County This is what my default MailMerge looks like at the moment: «Title» «Last_Name» «Company» «Address_1» «Address_2»

XP pro, Office 2003 pro I am trying to automate a mailing from multiple Excel workbooks. Even though I have only 1 worksheet in each book, my routine still pauses waiting for me to select the worksheet before completing the merge, How do i tell Word to continue, using the only worksheet there,...

This is a simple question but I can't remember how to do this. First of all I am using Microsoft Word 2003. What I am trying to do is a mail merge from an excel worksheet. Normally I have no problems doing this but unfortunately the worksheet I was given does not have the Title row as the first...

I have a spreadsheet with a list of Salesforce reports (column A), URLs to those reports (Column B), and the names of the report owners (Column C). I want to send the report owners an email that shows a list of reports, each on its own line and each one hyperlinked to the report in Salesforce. Some...

Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing and then have it move on to...

I have lots of Stamps.com 3-part multi-purpose labels and would like to use them. Does anyone have a templat for them for use in mailing?

I am having an issue with trying to multiply the number from the database by 1.2 I think the issue might be that the number is coming through with a dollar sign in front of it (Ex: $343,000) and the mergefield may be reading it as text, rather than a number. Can anyone help with this? Thanks.

Hi all, say I have a conditional as follows: {IF {mergefield product_name} != "shipping" "{mergefield product_name}" ""} and the value output from mergefield product_name may or may not have a single or double quote in it (our product names can have a single quote for feet, or a double quote for...

Hi, I already have the premade with blank information post cards. I am using mail merge to print the information on one side. I have to print the address on the back side of the postcard. How do I do it? I have seen several posts on this forum but could not find a solution. I am using word 2013....

Hi I am trying to do a mail merge where I have no access to edit the original data. I have a field that currently sits to 2 decimal places but I want the figure to pull through with either no decimal place or 1 if it is not a whole number. I have tried using #.# which works for those with a...

Hello, I need help creating a statement to insert a page break in my mail merge based on conditions such as the name changing on the record set. I've seen examples on this weekend from back in 2005 but I couldn't get any of it to work in Word 2017. I need help!